Does anyone have any suggestions on how to determine the value?
Under column A, there is a list of number, and under column B, there is a
list of marks. Some marks will be missing, which can be ignored.
I would like to determine the marks for the minimum number under column A.
In following case, it should return 30% in cell C1, because 2 is the minimum
number with marks.
Does anyone have any suggestions?
Thank anyone very much for any suggestions
Eric

1
2 30%
3 40%
4
5 60%