Forum Discussion
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...
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.