Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date range table array formula
OK I am still trying to figure out an old problem OK if make the sheet simple A1 A2 A3 EMP # Date EMP Profile code TAble array is set up like L1 M1 N1 O1 Agent # Start Date End Date EMP profile code 177721 1-1-2009 5-31-2009 1234 177721 6-1-2009 12-31-2009 5678 Ok so the big issue is the emp will chage profile peroidically thoughout a calander year. I am trying to get were in A1 is you enter the EMP # and then in B1 you enter a random date the correct profile code will come up in C1 based on the date range in the of table array the emp was profiled to the code =SUMPRODUCT(--(A1=L1:L9),--(B1=M1:M9),--(B1<=N1:N9),O1:O9) if not woeking me only, it sticks a 0 regardless of the emp and date entered. completely open to re-structering the array is needed. As matter of fact the table array is a work in progress |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
different formula for ROW, array / range? | Excel Discussion (Misc queries) | |||
array formula with a dynamic range. | Excel Worksheet Functions | |||
how to use * wildcard in a sum(if((cond),range)) array formula | Excel Worksheet Functions | |||
#VALUE! On An Array Formula Referencing a Range Outside The Workbo | Excel Discussion (Misc queries) | |||
Array Formula, noncontigous range | Excel Worksheet Functions |