Good afternoon All,
I have the following array formula which works perfectly and returns a listing of unique values from a list based on a condition. Could someone help me tweak this using the "small" function so that the list that is returned is in numerical order.
=IFERROR(INDEX('[Chemistry Source Data.xlsm]Data'!$B$2:$B$10000,MATCH(0,COUNTIF($A$1:$A81,'[Chemistry Source Data.xlsm]Data'!$B$2:$B$10000)+('[Chemistry Source Data.xlsm]Data'!$O$2:$O$10000<>'Indiv Lab Rep'!$E$4),0),COLUMN(A81)),"")
Thank you
H
I have the following array formula which works perfectly and returns a listing of unique values from a list based on a condition. Could someone help me tweak this using the "small" function so that the list that is returned is in numerical order.
=IFERROR(INDEX('[Chemistry Source Data.xlsm]Data'!$B$2:$B$10000,MATCH(0,COUNTIF($A$1:$A81,'[Chemistry Source Data.xlsm]Data'!$B$2:$B$10000)+('[Chemistry Source Data.xlsm]Data'!$O$2:$O$10000<>'Indiv Lab Rep'!$E$4),0),COLUMN(A81)),"")
Thank you
H