logonwheeler
New Member
- Joined
- Feb 1, 2014
- Messages
- 17
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:
1 A
2 D
3 A
4 C
5 B
6 D
7 C
8 B
9 A
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:
1 A
2 D
3 A
4 C
5 B
6 D
7 C
8 B
9 A