easy5 pts · first answer countsexceldynamic-arrays

Referring to a whole spilled list

E2 holds =UNIQUE(C2:C3001), which spills down. What does =COUNTA(E2#) count?

A.Only the value in cell E2B.The number of # signs typed anywhere in column EC.All values in E2's spill range, at any lengthD.Every non-empty cell in column E, including headers

Discussion 0

Join free to post in the discussion.

Referring to a whole spilled list

Discussion 0

Related questions