Hi,
I have an excel sheet where Column A is 'App ID' which is unique and it also has 20 other columns of data. The problem is not every row has equal number of columns. Some may have 10 and others 15, 20. So basically the data except Column A is jumbled.
I have a sheet 2 full of App ID's and I'm trying to find a specific text for each of these App ID's and trying to find what column number the text is located in.
I don't mind if the result is the cell address, column number or the actual cell contents. I just need to know where that specifix text is for each of the unique App ID's.
Example:
assuming my Sheet 1 is what the above table is, If I have to know which column the word Basketball contains, my result should look like:
Column A Column B
1 4
2 NA
3 NA
4 NA
5 3
I have an excel sheet where Column A is 'App ID' which is unique and it also has 20 other columns of data. The problem is not every row has equal number of columns. Some may have 10 and others 15, 20. So basically the data except Column A is jumbled.
I have a sheet 2 full of App ID's and I'm trying to find a specific text for each of these App ID's and trying to find what column number the text is located in.
I don't mind if the result is the cell address, column number or the actual cell contents. I just need to know where that specifix text is for each of the unique App ID's.
Example:
Column A | Column B | Column C | Column D |
1 | Jack Henry | 123 Main St | Playing Basketball |
2 | Mark Davis | 101 Main St | 1234567890 |
3 | David Warner | 102 Main St | test@test.com |
4 | Oswald Cobblepot | test@test.com | 123 Main St |
5 | Kathryn Aligator | Playing Basketball | 0987654321 |
assuming my Sheet 1 is what the above table is, If I have to know which column the word Basketball contains, my result should look like:
Column A Column B
1 4
2 NA
3 NA
4 NA
5 3