with a list of unique company codes in col Z

=MAX(IF($A$1:$A$100=Z1,$J$1:$J$100,"")
arra-enter this formula i.e. use CTRL+SHIFT+ENTER to insert it instead
of using just enter

then copy/drag down

pls click YES if it helped


On 2 Cze, 11:32, EricB wrote:
I’m 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