Sort the data in ascending and descending

[Ann123]

Restaurant ID	City	Jan	Feb	Mar	Apr	May	June
1200333​	Chicago	18225​	15184​	98984​	1500​	71111​	7889​
1200352​	New York	15184​	15845​	41545​	1622​	15151​	15184​
1200669​	Seattle	15845​	11112​	15184​	15184​	78787​	15845​
1200888​	Washington	11112​	15455​	15845​	15845​	10000​	11112​
1200989​	Kansas City	15455​	15454​	11112​	11112​	20000​	10000​
1200444​	San Jose	15454​	18498​	15455​	15184​	18498​	20000​
1200358​	Dallas	78888​	48211​	15454​	15845​	48211​	15000​
1200289​	Miami	48211​	16595​	18498​	11112​	16595​	15151​
1200739​	New Orleans	16595​	15487​	48211​	78787​	45484​	44544​
1200498​	Phoenix	15487​	56451​	16595​	15487​	15184​	1515​
1200789​	Madison	56451​	78451​	15487​	87844​	15845​	5655​
1200432​	Jersey City	12121​	14414​	56451​	89894​	11112​	8985​

2. Arrange the data above in excel in an ascending and descending order for each city.

This is one of the activites I have to do in my project as part of my studies. Can anyone guide on this, how to do it based on "each city"?
Appreciate your guidance.
Thank you,
Ann

 

[pecoflyer]

As this is clearly homework, do not expect the board to solve it for you, but you probably will get pointers.
What have you already tried and where did it go wrong?

 

[GraH - Guido]

Hi,
How do you do any sorting? Maybe you can:
1. look on the data tab.

2. or on the home tab

3. use the mouse

4. or when filters on, do this


And I may forget some of the options.

 

[Ann123]

As this is clearly homework, do not expect the board to solve it for you, but you probably will get pointers.
What have you already tried and where did it go wrong?

Ofcourse, homework is my reponsibility, I am not expecting exact solution...as I said I was confused on the "each city", otherwise it can be done easily. I tried it in multiple ways, and I wrote 3 ways, using cutom sorting... awaitng for my instructior to verify it.... thought of checking in forums to have a clarity on "each city" part.

 

[Ann123]

Hi,
How do you do any sorting? Maybe you can:
1. look on the data tab.
View attachment 74792
2. or on the home tab
View attachment 74793
3. use the mouse
View attachment 74794
4. or when filters on, do this
View attachment 74795

And I may forget some of the options.

Hi, I tried soritng on city, which resulted in arranging it alphbeticaly. When I did row wise, the months for reaaranged, which resulted in some values were not in ascending.... I did custom sorting and filtering, but May and June values are not correct.... I added a Total column and did, not sure thats what they asked or not, awaiting for my instructor to verify it..meanwhile I thought , let me try in forums for "each city" part... Thank you for your response, I will try the fourth option you mentioned ... thank you.

 

[GraH - Guido]

Hi, I tried soritng on city, which resulted in arranging it alphbeticaly

This is exactely what sorting does... on text values.

So it's about interpretation of the phrase "each city"... I find this strange wording then, since I can't see what it can mean. As there are no repeated values in the data. It could mean sorting on 2 levels: first on city, then restaurant ID.

Sorting column wise does not make any sense. Each row has a different sort order, then the column labels loose sense of meaning.

 

[Ann123]

This is exactely what sorting does... on text values.

So it's about interpretation of the phrase "each city"... I find this strange wording then, since I can't see what it can mean. As there are no repeated values in the data. It could mean sorting on 2 levels: first on city, then restaurant ID.

Sorting column wise does not make any sense. Each row has a different sort order, then the column labels loose sense of meaning.

Hi, Discussed with my instructor, your 4th method was correct .
My instructor told first do a filter on city, then do ascending..again do the same for descending... like that do for each city.... she added as the question has "each city" and it has sepecified months in the table, we cannot add multiple levels in custom sorting . Thank you.