7mþŸU. íè dÈ"Times New RomanN123L&Heading 1L ð < &Heading 2Lð ð < &Heading 3L .Bullet listO ³•Swissÿÿÿÿh3r h3r ÐР \cefd\cDefLdý‚.ÆAA!Bubblesort Explained.Bubbesort is looking through a list, picking out the highest an placing it at the top of the list (Steve - I know it's actually swapping pairs, but this is quicker, and logically identical, okay!), and looking at the remaining numbers for the next highest, etc. it's long and repetetive - just what a spreadsheet is good for!The Spreadsheet.The example sheet (bubble.spr - old habits die hard) takes the names of a popular boy band, and gives each of them a score. It takes these and outputs a sorted list of the band members' names.Creating the new Sort List.The list of the reference numbers is in Column E, with the relevant scores beside them in Column F.Finding the Highest Value.Cell G5 uses the MAX function to discover the highest score, and the rest of Column G copies over the reference number unless that score is the highest - in which case the word "max" is shown.Coumn H creates an ordered list of numbers, from 0 to as high as needed. The "max" value is labelled as 1, and everything before it as 0. This is becasue the LOOKUP function only works on ordered lists. By definition we start with an unordered list.(If I think about it, this could probably be condensed into one column, but it's a lot clearer this way!)The reference number of the highest item is placed at the top of Column I, and the rest of the list is compressed to fill in the space in the rest of the column.Continuing the Sort.The first (highest) number has bubbled to the top of our list. We now have a list with one less item, so we repeat the process to get the next highest score, etc, until we reach the end of the list.Finished SortBy copying over Column I (and it's counterparts) to the end of the bubblesort table, Column U shows the reference numbers sorted by the score criteria. We can now do what we want with these figures. In this example sheet, the names and scores are copied to a table below the main table to show an ordered list. But as with any spreadsheet skill, only your imagination (and lateral skills!) will limit what you can do. Think big! (Steve - like a GP Season score sheet!) "Arial "Arial "ArialFÁdÁúj¢ÇÕm "Arial  "ArialÏ "Arial "Arial™ "Arial "Arial! "Arial "Arialc "Arial "Arialw "Arial "ArialD "Arial¡ "Arial "Arial "Arial "Arial  "Arial "ArialÔ "Arial "Arial"Word.app C"yCR ‰!