Thread: using nested OR
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default using nested OR
I took the liberty to modify your formula
so a separate list can be used:
Groups
firm
llc
company
partnership

=RIGHT(A1,SUMPRODUCT(COUNTIF(A1,"*"&Groups)*LEN(Gr oups)))

Reply With QuoteReply With Quote