I don't really know how best to explain this but Attached is a worksheet that has multiple columns of names and figures. At the end I have the overall totals. I have added all the figures using a simple SUM() formula, that's easy but I am looking for a formula that I can use that will also bring the names along next to the overall figures column. You can see the highlighted column in yellow is in need of the names.
Your help would be much appreciated
Bookmarks