Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |