formula

[MAHMOUD-LEE]

Hi
I need the equation to bring the highest value in the column, through the cell search if you can not find brings value that followed in the same column

 

[Robert Mika]

Hello and welcome to MrExcel.
What you you mean by "can not find"?
Coudl there be two MAX values and you are looking for the second/third....?

For MAX value:
MS Excel: MAX Function (WS)

 

[MAHMOUD-LEE]

I do not mean function (max) but I mean
Is it possible through cell research to find the value of research in cell search if you can not find returns the value that directly followed the same column

 

[Robert Mika]

I do not mean function (max) but I mean
Is it possible through cell research to find the value of research in cell search if you can not find returns the value that directly followed the same column

Hmmm .
Could you post an example?

 

[MAHMOUD-LEE]

ADVERTISEMENT

10		1	cell search
11
4		3	if there is no column returns the value that followed in top ranking
7
8
3
9
20

<colgroup><col style="width:48pt" span="4" width="64"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> </colgroup><tbody>
</tbody>

 

[MAHMOUD-LEE]

up

 

[Robert Mika]

ADVERTISEMENT

10		1	cell search
11
4		3	if there is no column returns the value that followed in top ranking
7
8
3
9
20

<tbody>
</tbody>

Excel 2010
	A	B	C	D
1	10		1	3
2	11
3	4		3
4	7
5	8
6	3
7	9
8	20
Sheet1

Cell Formulas
Range	Formula
D1	{=SMALL(IF(A1:A8>=C1,A1:A8),1)}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[MAHMOUD-LEE]

very very good thank you

 

[MAHMOUD-LEE]

very very good thank you

 

[Robert Mika]

very very good thank you

You are welcome.