Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter or Look up?
I have a large worksheet of data (approx 1500 rows) that has 5 columns at the
far right that identify exceptions or changes between 2 worksheets. I want an end product that is all on one page and only lists the rows that have exceptions. This one page report would have all 5 types of exceptions on one page. I started with a simple filter for each column but I can only show one type of exception at a time. Any suggestions? K |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter or Look up?
K wrote:
I have a large worksheet of data (approx 1500 rows) that has 5 columns at the far right that identify exceptions or changes between 2 worksheets. I want an end product that is all on one page and only lists the rows that have exceptions. This one page report would have all 5 types of exceptions on one page. I started with a simple filter for each column but I can only show one type of exception at a time. Any suggestions? K Hi K, it depends on *how* did you built your 5 columns. If you used some VLOOKUP formulas, you will have some #N/D or some 0 or some "" (i.e. some blanks) where you don't have any exceptions or changes between the two worksheets. I think you could add another column to check if there is a value different from a blank or 0 or #N/D in the 5 columns and than filter on this sixth column. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter or Look up?
That is exactly what i ended up doing, thanks,
K "Franz Verga" wrote: K wrote: I have a large worksheet of data (approx 1500 rows) that has 5 columns at the far right that identify exceptions or changes between 2 worksheets. I want an end product that is all on one page and only lists the rows that have exceptions. This one page report would have all 5 types of exceptions on one page. I started with a simple filter for each column but I can only show one type of exception at a time. Any suggestions? K Hi K, it depends on *how* did you built your 5 columns. If you used some VLOOKUP formulas, you will have some #N/D or some 0 or some "" (i.e. some blanks) where you don't have any exceptions or changes between the two worksheets. I think you could add another column to check if there is a value different from a blank or 0 or #N/D in the 5 columns and than filter on this sixth column. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |