Timeline for Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 21 at 11:37 | comment | added | JaneM | Thanks I've got the answer now. The correct formula is: =SORTBY(A1:D206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1) which will sort data alpha numeric and also return 4 rows of data. | |
| Jun 21 at 8:42 | history | edited | JaneM | CC BY-SA 4.0 |
deleted 12 characters in body
|
| Jun 21 at 8:42 | history | edited | JaneM | CC BY-SA 4.0 |
added 38 characters in body
|
| Jun 21 at 8:41 | history | edited | JaneM | CC BY-SA 4.0 |
added 82 characters in body
|
| Jun 21 at 8:32 | comment | added | JaneM | So, I can sort A1-A100 in column 1 fine but the data consists of e.g. A1 then 3 rows of data going across, I'm looking to sort all 4 rows together eg. on one row there is the alpha numeric A1, then in column 2 on row 1 a number, then in column 3 a number, then in column 4 a number all on one row. Are you able to provide an example of how/where the other 3 go in the existing forumla I am using please? | |
| Jun 21 at 8:29 | comment | added | JaneM | Thanks but I'm unsure where/how the other 3 need to be put. | |
| Jun 20 at 14:57 | comment | added | gns100 |
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).
|
|
| Jun 20 at 14:52 | comment | added | Engineer Toast | It would be helpful to post a snippet of your data and a mocked up version of what you want the result to be. | |
| Jun 20 at 14:51 | history | edited | Engineer Toast | CC BY-SA 4.0 |
Separated the formula for readability.
|
| Jun 20 at 12:53 | history | edited | JaneM | CC BY-SA 4.0 |
edited title
|
| Jun 20 at 12:49 | comment | added | Reddy Lutonadio | @JaneM Click on this link to edit your question. | |
| Jun 20 at 12:47 | history | edited | JaneM | CC BY-SA 4.0 |
edited title
|
| Jun 20 at 12:43 | comment | added | JaneM | Thank you where do I find the edit option please? | |
| Jun 20 at 12:34 | comment | added | End Antisemitic Hate | Welcome Jane! Can you please edit the title of your question to make it more readable? Thanks, and again, welcome! | |
| S Jun 20 at 12:29 | review | First questions | |||
| Jun 20 at 13:05 | |||||
| S Jun 20 at 12:29 | history | asked | JaneM | CC BY-SA 4.0 |