I am creating an auditor spreadsheet for an upcoming pageant. Once all scores are entered, Im trying to gather grand totals and then sorting them in the order from winner to runner ups. I have the contestants name in one column and then I copied their totals from all the categories from the actual score sheets to add the two together. Once I have this data Im trying to sort according to highest score to least. It will not sort these and keep their names attached to their score. For some reason when I sort largest to smallest it will not sort highest number to lowest and its not keeping the contestant name attached to their particular score. Hope this makes sense lol
