| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Value (and Total) Based on Two Criteria
Pivot Table requires no formulas at all.
For the 8-Jan table: Layout: Row = DATE, ID; Data = Sum of NUMBER From the DATE dropdown list, select only 8-Jan For the 8-Jan thru 12-Jan table: Layout: Row = ID; Data = Sum of NUMBER |
Threaded Mode
