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
|