Common word in line

F

Fernando Gomez

I am analyzing a report with about 10000 transactions (Cheques paid) and I
want to know which lines contains the word "Rent" or "Rental".
Any help would be very much appreciated.

Fernando Gomez
 
J

Jason Morin

Assuming your transactions are in col. A, put this in
col. B and fill down:

=IF(SUM(COUNTIF(A1,{"*rent*","*rental*"}))>0,1,"")

Any row with a 1 next to it is means "rent" or "rental"
appears.

HTH
Jason
Atlanta, GA
 
F

Frank Kabel

Hi Jason
if you search for *rent* the search for *rental* is not required as it
is included in the first criteria
 
Top