Which cell has max value 2

[MToombs]

I have tried, but I can't figure out how to find out what cell has the max value. With =max(a1:1200) I can see the max value, but I would like to know which cell has the value.

 

[woja]

You need the [tt]MATCH[/tt] function, I think. But that'll require that your data is sorted and that the values are unique.

[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[SQLBI]

Hi,

I've managed to get the folowing formular to work as i think you need it to.

=ADDRESS(MATCH(MAX(A3:A10),A3:A10,0)+ROW(A3)-1,COLUMN(A3))

A3:A10 was my data range and my formula result seemed to be 100% spot on.

Let me know how you get on.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[MToombs]

Thanks - that works great!

 

[KenWright]

Just in case all you were looking to do is identify the cell visually, then you can use Conditional formatting, by selecting the whole range, doing Fomrat / conditional formatting, changing 'cell value is' to 'formula is' and putting :-

(using leigh's ranges)

=A3=MAX($A$3:$A$10)

Hit the format button, choose a nice pastel pattern, hit OK twice and you are done.

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------