kenderweasel
New Member
- Joined
- Feb 17, 2017
- Messages
- 40
Hi,
I have an array formula, which returns a list of text codes - at the moment, these are not sorted alphabetically, however, I've now been asked to change this to return the codes in alphabetical order. Can anyone help?
=IFERROR(INDEX(Database!$B$1:$DD$1,1,SMALL(IF(((Database!$C$1:$DD$1000=$A$16)+(Database!$C$1:$DD$1000=$A$17)+(Database!$C$1:$DD$1000=$A$18))*(Database!A$1:A$1000=$H$7),COLUMN(Database!$C$1:$DD$1000)),ROW(A1))-(ROW(A$2)-1),1),"")
I have an array formula, which returns a list of text codes - at the moment, these are not sorted alphabetically, however, I've now been asked to change this to return the codes in alphabetical order. Can anyone help?
=IFERROR(INDEX(Database!$B$1:$DD$1,1,SMALL(IF(((Database!$C$1:$DD$1000=$A$16)+(Database!$C$1:$DD$1000=$A$17)+(Database!$C$1:$DD$1000=$A$18))*(Database!A$1:A$1000=$H$7),COLUMN(Database!$C$1:$DD$1000)),ROW(A1))-(ROW(A$2)-1),1),"")