• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sort the data in ascending and descending

Ann123

New Member
Restaurant IDCityJanFebMarAprMayJune
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

Active Member
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

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

And I may forget some of the options.
 

Ann123

New Member
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

New Member
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

Well-Known Member
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

New Member
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.
 
Top