Forum Discussion
Eliminate Duplicates
I'm pulling data from an SP list. The list is made up of qualifications and certifications (1989 - 2020). Some of the qualifications repeat, as the employee needs to requalify periodically (1 per yr,...
Hi Anonymous ,
Can you show some sample data and expected result to us if you don't have any Confidential Information?
Best Regards,
Jay
Here is another version of the slide I provided at the top.
The desire is to ensure all data section totals ONLY reflect the most recent/active/noncompliant of any document names that repeat in the SP List for each Member.
There was a recommedation that I try Fitler/First, but that was later determined to not be the answer, and that method only reconciles the 'first' not duplicates.