Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

8
  • Welcome Jane! Can you please edit the title of your question to make it more readable? Thanks, and again, welcome! 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. 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. 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