Excel: Finding MIN text value from array excluding certain specified values


I am looking to return the MIN alphabetical text value from a list, with certain values excluded. I am currently using an array formula like this one to return the MIN alphabetical value in array A1:A9: =INDEX($A$1:$A$9,MATCH(0,COUNTIF($A$1:$A$9,">"&$A$1:$A$9),)) (+ CSE) Returns the value A However, I would like to return the MIN alphabetical value in the array EXCLUDING all A & D values. This result should return the value B. Can anyone suggest a nice way to achieve this? :confused: Data Set: 1 A 2 D 3 A 4 C 5 B 6 D 7 C 8 B 9 A


This question generated 47 answers. To proceed to the answers, click here.

This thread is current as of February 01, 2014.


For more resources for Microsoft Excel