Hi there,
I'm having problems getting a forumla to do the following - any ideas gratefully received.
The formula will be in Worksheet 1 and I am trying to count the number of rows on a Worksheet 2 where data in four columns matches, or contains, the data in four columns on a row in a Worksheet 3. In the following scenario, the result for the formula would be 2 as two rows on Worksheet 2 either match or contain data from rows on Worksheet 3. The only column that will have to 'contain' rather than match is Column D on Worskheet 2. There would be several thousand rows of data on each sheet.
Worksheet 2
Column A Column D Column E Column F
Billing 228359202 6 SMB
Access 123456701 6 SMB
Access 228359202 6 SMB
Worksheet 3
Column A Column F Column L Column P
Access 1234567 SMB 6
Access 2283592 SMB 6
I hope that makes sense, but please just let me know if you need any further info.
I'm having problems getting a forumla to do the following - any ideas gratefully received.
The formula will be in Worksheet 1 and I am trying to count the number of rows on a Worksheet 2 where data in four columns matches, or contains, the data in four columns on a row in a Worksheet 3. In the following scenario, the result for the formula would be 2 as two rows on Worksheet 2 either match or contain data from rows on Worksheet 3. The only column that will have to 'contain' rather than match is Column D on Worskheet 2. There would be several thousand rows of data on each sheet.
Worksheet 2
Column A Column D Column E Column F
Billing 228359202 6 SMB
Access 123456701 6 SMB
Access 228359202 6 SMB
Worksheet 3
Column A Column F Column L Column P
Access 1234567 SMB 6
Access 2283592 SMB 6
I hope that makes sense, but please just let me know if you need any further info.