View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JBeaucaire[_90_] JBeaucaire[_90_] is offline
external usenet poster
 
Posts: 222
Default Selectif function

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

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Cawshus" wrote:

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.



--
Stephen