- Hot Topics
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? Data Set: 4.16666666666667E-02 2 D 0.125 4 C 5 B 6 D 7 C 8 B 0.375
This question generated 47 answers. To proceed to the answers, click here.
This thread is current as of February 1, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel