LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Code advice please...

I have the following in a cell currently.
=IF(OR(ISNUMBER(SEARCH({"live","appoint"},J2&N2&R2 ))),"T","F")
I am looking for the works live or appointment in on of 3 cells.

I need to look for more words.
Would it be best at that point to use a user defined function or is there a
way to modify the above for more than 2 options?

Which would be the fastest?

I know I could do a function that would test for several varible using if
elseif else, but I am not sure which would be fastest, or how to modify the
above to test for three or four conditions.

Thanks
Bruce


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
any advice pls.. DumbLittleMan Excel Discussion (Misc queries) 1 September 4th 07 09:10 PM
pls advice dribler2 Excel Worksheet Functions 0 December 29th 06 02:22 PM
Little more advice on this code Greg B Excel Discussion (Misc queries) 3 September 3rd 05 05:31 AM
Almost got it !! but need advice Nospam Excel Worksheet Functions 6 February 28th 05 10:27 AM
Need advice and code help with working with *.dbf files in Excel 97 TBA[_2_] Excel Programming 1 September 8th 03 09:14 AM


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"