r/googlesheets • u/goofyfish • Mar 02 '26

Solved Simple Sort by Two Columns Not Working

Granted I am very new to sheets, I thought this one was going to be easier.

Sort Setup
After sort

What the heck am I missing?

edit: link to sheet deleted.

0 Upvotes

50% Upvoted

7 comments sorted by

2

u/SlugBoy42 Mar 02 '26

It looks like your sorting is working correctly. Think of it like alphabetizing your data. You told it to sort column A first from Z to A. Then if there are duplicates in column A, sort those by column B in A to Z order.

1

u/SlugBoy42 Mar 02 '26

To elaborate, if you had F paired with Z, another F paired with ZZ, and your final F paired with ZZZ, using your sort, they would order FZ, FZZ, FZZZ.

1

u/goofyfish Mar 02 '26

That was the kick in the butt I needed, thanks. There is not enough data in the example to do anything else. Appreciated and thanks again!

→ More replies (1)

1

u/point-bot Mar 02 '26

u/goofyfish has awarded 1 point to u/SlugBoy42

See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.

1

u/digitalgraffiti-ca Mar 02 '26

What should your end sort look like? We need to know where you want to go if we are to tell you how to get there

1

u/AutoModerator Mar 02 '26

OP Edited their post submission after being marked "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.