| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula, Should I be using Max?
I have a spreadsheet that looks like this. Date tank tank 1 2 1/10/06 999 7500 This data is kept on a daily basis. I am trying to find a formula that will return the latest date, but only if the tank value is at 999, as in tank 1 I have tried =MAX(IF(tank1=999,A3:A47," ")) returns Max of A3:A47 only and =IF(tank1=999,MAX(A4:A48)," ") returns Max of A only both return only the latetest date. What am I missing? Thanks in advance Deb -- Deb Pingel ------------------------------------------------------------------------ Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119 View this thread: http://www.excelforum.com/showthread...hreadid=513028 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
