Thread: Efficient way of finding string and changing cell value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
geoff_ness geoff_ness is offline
external usenet poster
  
Posts: 15
Default Efficient way of finding string and changing cell value
On Jan 24, 10:36*pm, ulfb wrote:
As amateur I would appreciate your help:

My sheet has 30 000 rows. In col D I need to find "district", not case
sensitive, beeing part of a longer string. If true, value in col C should be
set to "Dis".

Using VBA, Excel 2003 - how can this be done in shortest possible time?
Filter, Find, Search or ??

Thank you!

In C1, try =IF(ISERROR(SEARCH("district",D1)),"","Dis")
Reply With QuoteReply With Quote