Forum Discussion
Formulas
Hi all, I have a list of names where some recur. I trying to find a formula that will create a list of all the names but without the duplicates. Does this exist? Thanks so much Drew
My non-array version of that which was suggested by Subodh_Tiwari_sktneer is:
=IFNA(LOOKUP(2,1/(
COUNTIF(A$2:A$25,">="&A$2:A$25)=AGGREGATE(14,6,
COUNTIF(A$2:A$25,">="&A$2:A$25)/(COUNTIF(C$1:C1,A$2:A$25)=0),ROW()-1)),
A$2:A$25),"")