Even with that formula, =IF(MAX(($A$2:$A$20000=A2)*$K$2:$K$20000),"Max","" ) I
still get Max for all the cells.

"Gord Dibben" wrote:

=MAX(($A$2:$A$20000=A2)*$K$2:$K$20000)

Enter the formula using CTRL + SHIFT + ENTER


Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 09:37:01 -0700, Erika
wrote:

Actually I am not getting it to work I am getting a #Value error - the
forumla is erroring out in the first line
K2=MAX(($A$2:$A$20000=A2)*$K$2:$K$20000 it is trying to find the highest
value for each unit the units are in column A.

Why would I be gettingthe #value error?

"Sean Timmons" wrote:

Sounds like one of the cells in either A or K is #VALUE. works fine for me...

"Erika" wrote:

I use to have this formula working in Office 2003 and now I am getting a
value error - anyone see what is going wrong?

=IF(K2=MAX(($A$2:$A$20000=A2)*$K$2:$K$20000),"Max" ,"")

It is suppose to look through the list find the hight value and put the work
max in the cell with the highest value