Hi
Thanks in advance for any help
I need a formula which sorts two columns, 1 ascending and the other descending within a range
Attached an example
Thanks
Hi
Thanks in advance for any help
I need a formula which sorts two columns, 1 ascending and the other descending within a range
Attached an example
Thanks
Like this?
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You can also use sort likeFormula:Please Login or Register to view this content.
Thanks for coming back to me
In excel it works perfect but in Google sheets get unknown sort by, any ideas?
Thanks
And to include the headings:
Formula:Please Login or Register to view this content.
Nope I don't use sheets.in Google sheets get unknown sort by, any ideas?
You're posting in an Excel Forum with a stated profile of Office 365. Your thread is titled: "Sort by formula - two columns". And the sample file is called SortByExample.xlsx. Why would we consider a solution for Google Sheets?
Looks like Fluff's solution, or a variation of it might work: https://support.google.com/docs/answer/3093150?hl=en-GB
I have moved this thread to the appropriate forum section and added GoogleSheets to the thread title.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this:
=SORT(A2:E7,4,0,5,1)
You can see in this sample file:
https://docs.google.com/spreadsheets...gid=2100307022
If the results are not what you expect.. then you should first do something about your DIV errors by wrapping your original formula in IFERROR() function.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Hi
That's great, it worked
Sorry for delayed reply, really appreciate it
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks