
Announcements
I 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?
Found answer in this feed: Re: Adding a "@" in formula, while using Write to ... - Power Platform Community (microsoft.com)