Maths Question...

[Mr-Wizard]

Hi guys,

I have two columns, each contains 101 different values, I want to fin
the row that contains the highest possible value from each colum
without it resorting the rows, any ideas?


Standard Deviation has been mentioned, but we're not totally sure. An
help appreciated

 

[Bernie Deitrick]

Mr. Wizard,

If you want the value, use

=MAX(A:A)

for the row, use

=MATCH(MAX(A:A),A:A,FALSE)

Same for column B. Not sure if you wanted some cross column dependency or
not.....

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi
try
=MATCH(MAX(A1:A1000),A1:A1000,0)
and
=MATCH(MAX(B1:B1000),B1:B1000,0)

 

[Mr-Wizard]

Thanks guys,


Frank: that tells me the position of the highest value within the rang
for each column. How can I get the two formulas to work together s
they return the highest possible value for each colmun?

many thank

 

[Frank Kabel]

Hi
not sure what you mean with this. The highest value in the total
range?. Can you give an example?