MAX/MAXA Formula not returning required value
I tried both options:
=MAX(IF('Raw Data '!$A$2:$A$5000=A2,'Raw Data '!$J$2:$J$5000,"")) ..... Returns a #VALUE error
=MAX(IF(A$2:A$5000=A2,'Raw Data '!J$2:J$5000)) ..... Returns the maximum value of '20090530' for all the cells.
I substituted A2 with the numeric value but with no change.
Regards
EricB
"Jarek Kujawa" wrote:
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:
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
|