Hi
In A3 to B7 I have data as shown below, I want to display in E4 the minimum value of B3:B7 and in D4 the corresponding Option reference ie. A,B,C etc.
I cant lay the table out the other way round so as I could use a simple lookup.
Can anyone help please
In A3 to B7 I have data as shown below, I want to display in E4 the minimum value of B3:B7 and in D4 the corresponding Option reference ie. A,B,C etc.
I cant lay the table out the other way round so as I could use a simple lookup.
Can anyone help please
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
2 | Option | Value | MinimumValue | ||||
3 | A | 75 | OptionNo | Value | |||
4 | B | 22 | |||||
5 | C | 67 | |||||
6 | D | 45 | |||||
7 | E | 12 | |||||
8 | F | 99 | |||||
Sheet1 |