How to determine the value?
 

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%

How to determine the value?
 

In C1, array-entered (CSE): =MIN(IF(A1:A10<"",A1:A10))
CSE = press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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%

How to determine the value?
 

Hi Max:
The score is on the B column, and it should return the score based on the
minimum number under A column. The return score should be 30% for number 2,
because the score for number 1 is null, and should be ignore.
Do you have any suggestions?
Thank you for any suggestions
Eric

"Max" wrote:

In C1, array-entered (CSE): =MIN(IF(A1:A10<"",A1:A10))
CSE = press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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%

How to determine the value?
 

Probably this then ..
In C1, array-entered (CSE):
=INDEX(B1:B10,MATCH(MIN(IF(B1:B10<"",A1:A10)),IF( B1:B10<"",A1:A10),0))
Format C1 as perentage
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Hi Max:
The score is on the B column, and it should return the score based on the
minimum number under A column. The return score should be 30% for number 2,
because the score for number 1 is null, and should be ignore.