Hi, I'm really new at excel and I be this is probably a simple formula, but after reading im going around and around in circles.
I'll try to put it simply with a pic.
Each month i run a report. A top 5 tally.
Column B lists peoples names, sometimes these same people appear several times
Column C has a tally number next to them
Basically i want run a report that summarises the names in Column B putting them into Column N and adds up their respective tally number from Column C to their respective numbers in Column O
Screen Shot 2020-01-22 at 6.39.03 pm.png
thank you in advance.
Bookmarks