jakeman
Active Member
- Joined
- Apr 29, 2008
- Messages
- 325
- Office Version
- 365
- Platform
- Windows
Hello - so I am working with two lists of data that I would like to compare. One list is called PCP_Selections and the other is called PCP_Data. PCP_Selections is a much smaller list and may have anywhere from 1 - 7 names in that list. In the PCP_Data list, there are over 2000 rows and it has two other columns that are relevant to me: Date and Member Total.
What I would like to do is compare the PCP_Selections list to the PCP_Data list and where there is a match on the name, I would then like to sum the Member Totals for a given period of time. So for example, in my PCP_Selections list, I have 5 names and I am interested in seeing what the total number of Members were for Q1 2013.
Hope I explained myself clearly.
What I would like to do is compare the PCP_Selections list to the PCP_Data list and where there is a match on the name, I would then like to sum the Member Totals for a given period of time. So for example, in my PCP_Selections list, I have 5 names and I am interested in seeing what the total number of Members were for Q1 2013.
Hope I explained myself clearly.