0

I have used this formula to sort the column A1 to A100 so that A

=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)

thanks to one of your posts: Advanced sorting of alphanumeric data

However, how do I get this to work across four columns of data to retain the sort order of the other columns please?

Copy of sample results in link, thanks Sample data

Improve this question
8
  • Welcome Jane! Can you please edit the title of your question to make it more readable? Thanks, and again, welcome!
    – End Antisemitic Hate
    Commented Jun 20 at 12:34
  • Thank you where do I find the edit option please?
    – JaneM
    Commented Jun 20 at 12:43
  • @JaneM Click on this link to edit your question.
    – Reddy Lutonadio
    Commented Jun 20 at 12:49
  • It would be helpful to post a snippet of your data and a mocked up version of what you want the result to be.
    – Engineer Toast
    Commented Jun 20 at 14:52
  • I suggest you look at examples of the SORTBY() function. If you hadn't realized, your formula already has two sort by criteria, just add the other 3 in there (probably before your 2 existing criteria).
    – gns100
    Commented Jun 20 at 14:57

0

Reset to default

You must log in to answer this question.