Lesson 5: Randomising an Excel List

Now that you have learned how to reverse an Excel List, let’s extend our creativity further and learn how to randomise (shuffle) a list in Excel. Exercise For example, we want to randomise the list below. Download the zip archive Randomise-list, extract and open file “randomize-list.xlsx” Select cell C1 and insert the RAND() function. Click in cell […]

Lesson 4: Reversing an Excel List

This lesson follows on from the lesson: Sorting a range on colour We shall now learn how to reverse a list in Excel. Exercise Please download the zip archive “Reversing a list”, extract and open the file Reversing a list.xlsx We may, for example, want to reverse the list in column A below Method 1 Enter the […]