Hello Karan,
In C2, with CTRL+SHIFT+ENTER, and copy down.
=IFERROR(INDEX(A$2:A$100,MATCH(1,IF(A$2:A$100<>"",IF(ISNA(MATCH(A$2:A$100,C$1:C1,0)),1)),0)),"")
If you need Unique Names in *Ascending Order*,
In C2, with CTRL+SHIFT+ENTER, and copy down.
=IFERROR(INDEX(A$2:A$100,MATCH(0,IF(A$2:A$100<>
ject: $$Excel-Macros$$ Re: Unique Name Query
Hello Karan,
In C2, with CTRL+SHIFT+ENTER, and copy down.
=IFERROR(INDEX(A$2:A$100,MATCH(1,IF(A$2:A$100<>"",IF(ISNA(MATCH(A$2:A$100,C$1:C1,0)),1)),0)),"")
If you need Unique Names in Ascending Order,
In C2, with CTRL+SHIFT+ENTER,