View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Identify if Text is in that row and return True or False

Let's assume the row is from column A to column L.

=COUNTIF(A1:L1,"PAINM")0

--
Biff
Microsoft Excel MVP


"klmiura" wrote in message
...
I have a worksheet that has several columns and I want a formula to
identify
that row as true or false if it contains the following text: PAINM

I want to put this formula at the end of the row and just have it state
True if it is in that row or False if it is not.

Thanks
Karen