Selectif function

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.
 
C

Cawshus

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.
 
J

JBeaucaire

I would turn on AutoFilter, then in the column in question use the drop down
arrow and select CUSTOM.
 
Top