Originally Posted by
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
.
.
.
2000____3,15584375_______0,1605242
My problem:
How can I have displayed on a cell (e.g. F5) the maximal number of column B and on an other cell (e.g. E5) the value of column A which is on the same line as the maximal value of column B???
My question simplified:
I type on cell F5
=max(B:B)
and let us assume that the maximal value is located on cell B1547
How can I have displayed on cell E5 the value of cell A1547 ???
Normally I solve my problem by using the auto filter (Data->Filter->Autofilter). But this procedure is very disturbing and uncomfortable – consider that I have to repeat it many times and that the data-queue very long is …
Any other suggestions – script or function????
thanks
Bookmarks