kingspur06
Board Regular
- Joined
- Apr 24, 2007
- Messages
- 50
Hi - I am sure this is probably simple but I cannot get my head round it....
I have a report showing selected Clients in Column A and Contact Names in Column B.
There are duplicates of Clients in column A because there can be multiple contacts per client.
But there are also duplicates of Contact Names in Column B because those contacts may have worked at multiple clients.
I then have a separate master report with my all time clients and contacts.
I am trying to find a way on the master report to identify only the records that contain the exact combination of client and contact name in the other report.
I do not know how to request Excel to look at both Client and Contact together, and match it with both the Client and Contact in the Master Report.
many thanks for your help in advance!
Mark
I have a report showing selected Clients in Column A and Contact Names in Column B.
There are duplicates of Clients in column A because there can be multiple contacts per client.
But there are also duplicates of Contact Names in Column B because those contacts may have worked at multiple clients.
I then have a separate master report with my all time clients and contacts.
I am trying to find a way on the master report to identify only the records that contain the exact combination of client and contact name in the other report.
I do not know how to request Excel to look at both Client and Contact together, and match it with both the Client and Contact in the Master Report.
many thanks for your help in advance!
Mark