More Easy way for alphabetic listing ?
- Thread starter Dackson
- Start date
Somendra Misra
Excel Ninja
Hi Dackson,
I assume you are trying to sort column F list in alphabetical order A-Z, if so than try below array formula in G2 and copy down:
=INDEX($F$2:$F$11,MATCH(ROWS(G$2:G2),COUNTIF($F$2:$F$11,"<"&$F$2:$F$11)+1,0))
Note, since this is an array formula so must be confirmed with Ctrl+Shift+Enter, and not just Enter.
Regards,
I assume you are trying to sort column F list in alphabetical order A-Z, if so than try below array formula in G2 and copy down:
=INDEX($F$2:$F$11,MATCH(ROWS(G$2:G2),COUNTIF($F$2:$F$11,"<"&$F$2:$F$11)+1,0))
Note, since this is an array formula so must be confirmed with Ctrl+Shift+Enter, and not just Enter.
Regards,