Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
report.!
hi!
i am having a2:a12 names; b1:g1 months; b2:g12 flags ("y" for reports received, "blank" for not received) is there any easy way to find out the names who have defaulted in sending reports and the months of default in a single report..? NAME Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 A Y Y Y Y B Y Y Y C Y Y Y Y D Y Y Y Y Y Y E Y Y Y F Y Y Y Y G Y H Y Y Y Y Y I Y Y Y Y J Y Y Y Y Y K -via135 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Print Report W/Sub Report | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) | |||
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) |