Is there a formula to sort by dates along with subsequent columns.....?
See Attached.....thanks
Is there a formula to sort by dates along with subsequent columns.....?
See Attached.....thanks
You'll need to add a helper column to create a proper Excel date number i.e. in F2 down
=DATE(E3,C3,D3)
Then sort B3:F9 by column F Date as the first sort column - and by name if you want names on the same date in alphabetical order
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Sorry but I realized my ask was not clear. I am looking for a formula which will sort dynamically as data changes….
You can use a couple of helper columns:
F3: =DATE(E3,C3,D3)
which will give the proper date,
G3: =RANK(F3,F$3:F$9,1)+COUNTIF(F$3:F3,F3)-1
which will then rank the dates in ascending order (and account for duplicates, if any).
Copy down to the bottom of your data. Then you can use this formula in I3:
=INDEX(B:B,MATCH(ROWS($1:1),$G:$G,0))
Copy across and down as required.
Hope this helps.
Pete
Hi
As you have office 365, you can use the SORTBY function.
=SORTBY(B3:E9,DATE(E3:E9,C3:C9,D3:D9),1)
Last edited by Kevin UK; 05-06-2021 at 12:47 PM.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
I forgot to add, convert your data to a table, the SORTBY function will be then be dynamic.
Last edited by Kevin UK; 05-06-2021 at 01:15 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks