hi all - can anyone help on following
the data is as follow on worksheet A:
code status
zzz open
yyy open
ccc closed
ddd open
aaa open
i would like a returned list of open codes in ascending order on worksheet B as follow
code status
aaa open
ddd open
yyy open
zzz open
i currently have following which returns me the list of open codes, however not in sorted format
INDEX(Transactions!$A$2:$BB$89,SMALL(IF(Transactions!$C$2:$C$89=dStatusOpen,ROW(Transactions!$A$2:$A$89)-ROW(Transactions!$A$2)+1,ROW(Transactions!$A$89)+1),ROWS($A$19:A19)),1)
code status
zzz open
yyy open
ddd open
aaa open
column A is the code
column C is the status
thanks in advance for your help & efforts - jurgen
Bookmarks