Forum Discussion
DaleyT
Sep 09, 2022Copper Contributor
Member count help
Hi, So this might be a tough one to explain but I will give it a go.. I am using excel to highlight various key stats to my line manager based on our organisations membership stats (via a repo...
Riny_van_Eekelen
Sep 09, 2022Platinum Contributor
DaleyT One idea would be to use one of the available lookup functions. You can lookup old member is the new list. The ones found have renewed, the ones not found have not. Then you lookup the members from the new list in the old list. The ones not found are new members.
And if you want to go a bit more fancy you could automate it with Power Query.