Forum Discussion
Automating The Selection of High Values in Excel
I have Excel Data that looks like this: Last Site Test Score Amaya One Ops Skills 100 Brown Two Ops Skills 100 Garcia One Ops Skills 100 Garcia One Ops Skills 67 Jon...
If with Power Query you may query the source, sort ascending names and descending scores, fix in memory by adding index, remove duplicates by all columns but score, remove index, return result into Excel sheet.