Data Sort Ex 1
Sort the data so that the order is firstly by
- City but in the order of Johannesburg, Paris, London, New York
- Then by Product in the order of Basic, Standard, Deluxe
Data Sort Ex 2
This data is out of our Sales system but we need to columns to be in a different order. The order we want is shown in row 1 i.e. first Product, then Salesperson, then City, then Sales. Use Data Sort to Achieve this
Data Sort Ex 3
The manager has worked through the list and coloured the cells. We need to sort the data so that in appears in the following order:: Red, Yellow, Green