Search for numbers in entire dataset

Question

Hi,

I have a list of numbers:

How can I search in my largely unstructured dataset if these numbers exist in there?

The problem is I am trying to match these numbers in across many sheets in an excel workbook. However the excel workbook is formatted differently throughout each sheet.

Importing each sheet it is hard to parse out the relevant information.

FilipR · Answer

@wonka1234 Transpose will do the job for multiple columns. Please see attached.

Contains Numeric in String.yxmd

Jonathan-Sherman · Answer

Hi @wonka1234,

It would be easier to mock up an example if you could share the structure? But essentially if you've got multiple columns you want to search for a series of "tags" in then i'd go down the route of adding a RecordID and transposing all your data, then using a find and replace to append the "tag" as a new column so you can identify which cell / column have been flagged.

Kind regards,

Jonathan

wonka1234 · Answer

@FilipR

Yes like this, but I need to search multiple columns