It is col J..

if company code is numeric
=MAX(IF(A2:A100=8000,J2:J100))

if company code is text
=MAX(IF(A2:A100="8000",J2:J100))

--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try

if company code is numeric
=MAX(IF(A2:A100=8000,B2:B100))

if company code is text
=MAX(IF(A2:A100="8000",B2:B100))


If this post helps click Yes
---------------
Jacob Skaria


"EricB" wrote:

Im trying to get MAX to return a latest date/highest value but the same date
is returned in each cell;

In column €˜A I have company codes, in column €˜J I have dates in which
business was done with the company specified in €˜A.

A €¦€¦ J Formula result
1 8000 20070530
2 8000 20080530
3 8000 20090530 20090530
4 8050 20070530
5 8050 20080530 20080530
6 8100 20040530
7 8100 20050530
8 8100 20040530
9 8100 20060530 20060530

Presently MAX & MAXA is returning 20090530 for all cells, how can I obtain
above results as indicated under €˜Formula result?

Regards

EricB