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
|