| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
report by DV & date criteria
sheet1 - data -
date, field1, field2, field3, field4, field5 sheet 2 - filtered report - C1. begin date - if blank then till C2 if C2 is blank then all C2. end date - if blank then starts from C1 or all C3. field1 DV - if blank then all C4. field2 DV - if blank then all C5. field3 DV - if blank then all Report starting row . B8 - sort by date. Working on A8 formula for hours failed each time. Should I really resort to VBA ? Any help even a right direction ? Thank you very much. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
report by DV & date criteria
With helper columns I managed to create the report.
Starting from G8 as Date, Field1, Field2.etc Don't know how I can sort it by formula. Any idea ? Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
report by DV & date criteria
Done it with a helper sheet .
Thank you Max for AutoSort_DateOrder_.... wks. rgds |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| How can I set up week to date report? | Excel Worksheet Functions | |||
| Design Report for Excel Date | Excel Discussion (Misc queries) | |||
| urgent pls! sort date pivot report | Excel Discussion (Misc queries) | |||
Linear Mode
