Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarize information on another sheet
I've got a workbook set up with multiple tabs. Each tab represents a
different slice of detailed information that's auto-filtered based on a status in a master tab (ie - all info in the master tab, different filters in the other tabs.) I'd like to create a summary tab that shows a subset of the data on the individual tabs. I've been able to display counts of the information (countif...), but don't know how to display a couple of columns of the information. For example: master tab "1" tab "2" tab ------------ -------- -------- joe 1 2 3 joe 1 2 3 ron 2 6 7 sam 1 4 5 sam 1 4 5 kim 2 7 8 ron 2 6 7 abe 2 9 9 kim 2 7 8 abe 2 9 9 I'd like the summary tab to look like: task 1 task 2 ----------- -------- 2 people 3 people joe ron sam kim abe If I use an If statement to screen rows out, I get blank rows. If I use filters, the rows don't match so data isn't shown. Is there a way to do this without creating a macro to screen things out and condense them? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Information - Is sheet protected? | Excel Discussion (Misc queries) | |||
How do I automatically get information from sheet 1 into sheet 2 | Excel Discussion (Misc queries) | |||
Display rows meeting criteria on another sheet & summarize them | Excel Discussion (Misc queries) | |||
summarize data sheet | Excel Worksheet Functions | |||
Summarize multiple worksheet detail on summary sheet | Excel Discussion (Misc queries) |