Thread: Search Function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_90_] JBeaucaire[_90_] is offline
external usenet poster
 
Posts: 222
Default Search Function

Heh, forgot the SEARCH portion that time...
--
"Actually, I *am* a rocket scientist." -- JB

"T. Valko" wrote:

Another one that saves a couple of keystrokes:

=IF(SUM(COUNTIF(AC81,{"*VAR*","*Direct
Funding*","*Intercompany*"})),"Direct Fundings","")