Search Across Multiple Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that was created from a legacy database that I am trying
to do one-time clean-up. The data consist of 8300 business (rows) with
information specific to each business each columns (A-AA). Unfortunately
because of method of import, some of the information was spread into various
columns. i.e. Specific Code (ATM1500) was suppose to be in column J in each
row, but was found intermixed with other text data in columns J, K, L, M and
N. Not all rows have this Specific Code, but I want to find out which rows
have it.

I would like to create another column where I can place a value(True/False,
1/2, or the value itself) to show that a specific row has the value somewhere
in columns J-N. I am not sure Search/Find will work across multiple columns.

Thanks!

Windows XP Pro SP2/Excel 2003 Office Pro
 
Maybe you could use a helper column with a formula like:

=countif(J2:m2,"ATM1500")
to see the total count
=countif(J2:m2,"ATM1500")>0
to see true if it's there at least once.
or

(if the ATM1500 is in the cell with other stuff)
=countif(J2:m2,"*ATM1500*")
=countif(J2:m2,"*ATM1500*")>0
 
Back
Top