Paging Excel geeks

I hate working with spreadsheets, but they're just something I have to
use from time to time.

I have a spreadsheet set up vaguely like this:

Store Name Sales wks 23-37 Total Sales Average Sales

I want to sort the data, ranking it descending using either of the last
2 columns, but I want Excel to sort the rest of the data accordingly.

I'll be fucked if I can find a way of doing it.

So, FOAK, any ideas?

 

Fucking Excel...

Click the top row with your headers in it. Then, there's an option
under the menu Data called Sort.

Click that, you should get what you want.

 

Fucking Excel...

Click the top row with your headers in it. Then, there's an option
under the menu Data called Sort.

Click that, you should get what you want.

 

What do you mean by "the rest of the data"?

 

Store Name Sales wks 23-37 Total Sales Average Sales

I assume you found the sort option under the data menu? The other
columns should sorted as well as the first and last, if that's not
happening it's usually because Excel doesn't recognise the data being
sorted as a contiguous range maybe because you have empty cells and
columns within the range if so make sure you select the entire range
before sorting, this should do what you want.

 

Cheers, that's the one.

 

Yup, thanks.