View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K K is offline
external usenet poster
 
Posts: 108
Default 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