View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default advanced filter question

for an exact match you need something like

="A Labour - Hours"

I believe.

--
Regards,
Tom Ogilvy

"philcud" wrote in message
ps.com...
hi all,
i am using the advanced filter to copy matching records to another
location.
there are 5 criteria fields that the user selects from a drop down box,
but one of the fields has similair names eg :- "A Labour - Hours Cum"
and "A Labour" and "A Labour - Hours".
i need an exact match for the output as i need to separately report.
any ideas?