pauleverton
New Member
- Joined
- Feb 8, 2014
- Messages
- 23
Hi,
I'm trying to do a check against a few thousand rows to see if they contain the information within a column header - data is as below:
Columns A:Z - Information that we want to check
Columns AA:AZ - Row 1 contains the headers we want to validate, rows 2 & below contain where we need to put the results
I've put a brief example below - the aim is to check each value in each row to see if it contains the specific column header and, if so, output how many files on that row contain that information.
I've tried to create a double loop with an incremental count but it's just not processing as I want and I'm a bit stumped as to how to get this moving - any help would be really appreciated.
Thanks,
Paul
I'm trying to do a check against a few thousand rows to see if they contain the information within a column header - data is as below:
Columns A:Z - Information that we want to check
Columns AA:AZ - Row 1 contains the headers we want to validate, rows 2 & below contain where we need to put the results
I've put a brief example below - the aim is to check each value in each row to see if it contains the specific column header and, if so, output how many files on that row contain that information.
File 1 | File 2 | File 3 | File 4 | ...File Z | ABC | 123 | XYZ | 8910 |
eakgABC123 | 2234123ABC | XYZ8910 | 2 | 2 | 1 | 1 | ||
xxxxxx | yyyyyy | zzzzzz | 1111 | 2222 | 0 | 0 | 0 | 0 |
ABC123XYZ | ABC1238910 | 2 | 2 | 0 | 1 |
I've tried to create a double loop with an incremental count but it's just not processing as I want and I'm a bit stumped as to how to get this moving - any help would be really appreciated.
Thanks,
Paul