subject:"$$Excel\-Macros$$ Re\: Unique Name Query"

Re: $$Excel-Macros$$ Re: Unique Name Query

2012-07-09 Thread ANKUR AGGARWAL

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,

$$Excel-Macros$$ Re: Unique Name Query

2012-07-09 Thread Haseeb A

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<>