"&$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 .">
Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel