| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX/MAXA €“ Formula not returning required value
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel maxa | Excel Discussion (Misc queries) | |||
| MAX, MAXA functions | Excel Discussion (Misc queries) | |||
| MAX & MAXA returning 0 value | Excel Discussion (Misc queries) | |||
| Code required for VLookup returning #NA | Excel Discussion (Misc queries) | |||
| Countif, Maxa or other function? | Excel Worksheet Functions | |||
Threaded Mode
