The last time I had a question, this forum was invaluable. And I've been back many times to lookup the answers to my queries. But again this one has me stumped.
As before, please be gentle - I'm an excel amateur. Now very new to using 2010/13. No knowledge of VBA. Apologies if I get this a bit wrong. I have read the suggested post on this topic (http://www.ozgrid.com/forum/showthread.php?t=125581) but must admit to not understanding how to apply the answers in my case!
The output of my magic spreadsheet, developed to run the local flower show, is a column of names - each of which have won a prize valued in points. I need to determine which person in the list of names has won the most points in total, in order to award a trophy.
Actually, I also need to know how many points each individual has got because - as we all know - points make prizes. And I need to write out one prize voucher for each individual, to the total value of what they won.
Now I have been sorting each column alphabetically, then manually totting up the points, and adding the three totals together. But surely, there must be a way to do this automatically? I don't really want to have to sort the columns at all... just have the answers appear like magic once the data is in the data entry part of the sheet.
Here's an example:
When you tot up the points across the three sets of columns, you see that J Smith has £3.00, B Jones has £1.50, A Nother has 50p but F Bloggs wins overall with £4.00.
What's that you say? Why don't you keep on doing it manually? Well, that's because my real spreadsheet has 134 rows, and three sets of columns so there are 402 potential names to scan through. Plus different values of points/pounds for prizes.
I hope someone can help!
Happy to give more detail or answer queries as you solve my conundrum.