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
|