Display the the maximums left cell...

I

istratos

Hallo everybody!

I work with not normal distributions and I get data outputted in excel
work sheets. The final excel work sheet is a 2000 lines long csv
archive with two columns which include a large sequence of decimal
numbers. The sheet looks like this:
____________A_____________B
1_______2,624593_______8,58E-02
2_______2,644125_______8,75E-02
3_______2,663656_______0,084925
4_______2,683187_______8,66E-02
5_______2,702718_______0,084925
6_______2,722257_______8,58E-02
 
B

Bryan Hessey

The highest value is =MAX(B$2:B$999)

The corresponding cell i
=OFFSET(C$1,MATCH(MAX(B$2:B$999,0),B$2:B$999),0)

--
 
B

Bryan Hessey

The highest value is =MAX(B$2:B$999)

The corresponding cell i
=OFFSET(C$1,MATCH(MAX(B$2:B$999,0),B$2:B$999),0)

--
 
I

istratos

thank you for your suggestion
I used the folowing function

=INDEX(A:A;MATCH(MAX(B:B);B:B;0))

It helped me a lot...
 
Top