| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date formula errors
i have this formula that i am using as an array , but it gives me an error
message. i am trying to use the formula on a page called "calculations".. the information being used is on a page called "client" .. i am also indirectly referencing a cell "O1" on the calculations page so that i dont have to change the formulas all the time.. can someone tell me why this doesnt work?? =MAX(IF(INDIRECT("CLIENT!$I$2:$I"&$O$1)="HOMESIDE" ),(INDIRECT("CLIENT!$E$2:$E"&$O$1))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Date formula | Excel Worksheet Functions | |||
| Date Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
