Selectif function

  • Thread starter Thread starter Cawshus
  • Start date Start date
C

Cawshus

Hi

I need to be able to select in a worksheet all occurances of a user-
specified value (examples - select all zeros; select all values = "test").
The ability to specify exact match or contains would be useful.
Can someone point me in the right direction.
 
I would turn on AutoFilter, then in the column in question use the
drop down arrow and select CUSTOM.
Click to expand...


That would work in one row, I need it to work across a whole worksheet or
selected range.
 
I would turn on AutoFilter, then in the column in question use the drop down
arrow and select CUSTOM.
 
Back
Top