View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default formula using multiple ranges

You're welcome Wayne.......the AutoFilter should do what you want, giving all
the rows exceeding a certain value in a certain column.......

When finished, just do Data Filter AutoFilter again and it toggles off,
returning all data to normal........

And if it's something you have to do frequently, it can be automated with
macros..

Vaya con Dios,
Chuck, CABGx3





"Wayne Knazek" wrote:

Thanks, Chuck. This is all a bit new to me. I'll check out and try your
suggestion. :)

"CLR" wrote:

Have you considered Data Filter AutoFilter Custom (on your column of
interest) GreaterThan 100



Vaya con Dios,
Chuck, CABGx3