Please can anyone help me with an excel equation needed for my spreadsheet.
I have an excel spreadsheet in Windows 7 that shows a 2600 rows, and several columns. in each row is an item for sale with a price against it in two seperate columns. There is other data in the other columns also.
I need to apply a formula to affect every cell and its corresponding number in the 'price column'. It needs to sort out the numbers from high to low so that the lowest numbers appear at the beginning of the spreadsheet (top of the page) and graduate up in order so that the highest price is at the end of the spreadsheet (bottom of the page)
Many thanks in anticipation
Heather