Search for numbers in entire dataset

[wonka1234]

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.

[Emmanuel_G]

Hi @wonka1234 ,

Can you provide us a draft of input and output you want to obtain ?

Regards !

[FilipR]

Something like this?

[wonka1234]

@FilipR 

Yes like this, but I need to search multiple columns

[Jonathan-Sherman]

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

[FilipR]

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