medium10 pts · first answer countsexceldata-validationdynamic-arrays

A dropdown that grows with the data

H2 contains =SORT(UNIQUE(Sales[City])). What source should a data validation list use so new cities appear automatically?

A.=$H$2B.=$H:$HC.=UNIQUE($H$2)D.=$H$2#

Discussion 0

Join free to post in the discussion.