medium10 pts · first answer countsexceldynamic-arrays

Customers who ordered only once

Customer IDs are in A2:A5000, one row per order. What does =UNIQUE(A2:A5000,,TRUE) return?

A.Each ID once, sorted A to ZB.Each ID once, read across columnsC.IDs that appear more than one timeD.IDs that appear exactly one time

Discussion 0

Join free to post in the discussion.