Common word in line

  • Thread starter Thread starter Fernando Gomez
  • Start date Start date
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
 
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
 
Hi Jason
if you search for *rent* the search for *rental* is not required as it
is included in the first criteria
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find partial match from column A,B and fill partial match in C? 4
Data Table 4
Matching records based on a common field 1
Index/Match for the largest value that matches 1
How do I figure out amout due from transaction file 3
Word to Excel: Export comments with text and line number 0
Max Price and Min Price paid for an item 1
AOL 10

Back
Top