Maths Question...

  • Thread starter Thread starter Mr-Wizard
  • Start date Start date
M

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
 
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
 
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
 
Hi
not sure what you mean with this. The highest value in the total
range?. Can you give an example?
 
Back
Top