Formula Help

  • Thread starter Thread starter Erika
  • Start date Start date
E

Erika

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
 
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?
 
And you verified none of the cells in column A and column K have a #VALUE in
them... I don't see any error in the formula that would cause a #VALUE.
 
=MAX(($A$2:$A$20000=A2)*$K$2:$K$20000)

Enter the formula using CTRL + SHIFT + ENTER


Gord Dibben MS Excel MVP
 
Do I just press enter to exit the cell with the formula or do I need to press
ctrl+shift+enter?
 
The Values in column A are unit numbers and the values in column K are values
that were entered they are not the result of a formula? When I double click
in each cell and go into edit mode and then press enter to exit all of the
results are changing from #value to Max. However they all say Max.
 
Even with that formula, =IF(MAX(($A$2:$A$20000=A2)*$K$2:$K$20000),"Max","") I
still get Max for all the cells.
 
For whatever reason this formula is working perfectly where the other one was
not thank you all for your assistance.
 
As long as it works, we're happy! :-)

Erika said:
For whatever reason this formula is working perfectly where the other one was
not thank you all for your assistance.
Click to expand...
 
Back
Top