1. Does the length of TestEquip = the length of FINISH_Date?
2. Did you commit the array formula with CTRL SHIFT ENTER to get the
brackets?

HTH,
Barb Reinhardt

"Shrini" wrote:

Hello there,

I have a excel database, in which a equipment Name and there
utlisation date is given. I want to check the last date on which the
equipment was used and then plan new test on the equipment ahead of
this last available date. I have tried to use function like this

{=MAX(IF(Test_Equip=A1,Finish_Date))}

The function works for the ranges up to 339 rows. thereafter it gives
the formula result as #N/A.

Can any body help me out in this. I have tried to use direct range and
named ranges too. The actual data base is continuously increasing and
hence i have kept the lenght of named range at 50000 rows.

Regards,

Shriniwas.