Share
Report
14I am trying to generate a list of unique names from a list (over 200) in excel that has many duplicated names. I wrote into excel with =UNIQUE(A4:A%FirstFreeRow - 3%), but it was converted to =@UNIQUE(A4:A227), which only returns one unique name instead of returning a list of unique names. Does anyone know how to make sure that the @ symbol does not appear when writing into excel, or another option to generate a unique list?
Categories:
I have the same question (0)
All responses (
Answers (
