Is there a way to sort a column on just the date portion of a day+time field?

[JenniferMurphy]

Consider this table containing 7 items that each have a Last Used field and a Rating field.

Sorting.xlsx
	C	D	E
4	Item	Last Used	Rating
5	A	8/28/23 14:33	91
6	B	8/27/23 18:25	81
7	C	8/28/23 08:21	89
8	D	8/27/23 09:35	78
9	E	8/28/23 17:53	83
10	F	8/27/23 11:22	95
11	G	8/28/23 07:02	77
Dates

I would like to sort the table by Last Used (oldest to newest) and then by Rating (high to low). If I do that, I get this:

Sorting.xlsx
	C	D	E
4	Item	Last Used	Rating
5	D	8/27/23 09:35	78
6	F	8/27/23 11:22	95
7	B	8/27/23 18:25	81
8	G	8/28/23 07:02	77
9	C	8/28/23 08:21	89
10	A	8/28/23 14:33	91
11	E	8/28/23 17:53	83
Dates

In this sort, the Rating field is irrelevant because no two Last Used values are identical. There are many that happened on the same date, but at different times. I only want the sort to take into account the date portion of the Last Used field.

I can get the result I want by adding a helper column with just the date portion of the Last Used field.

Sorting.xlsx
	C	D	E	F
4	Item	Last Used	Rating	Date
5	F	8/27/23 11:22	95	8/27/23 00:00
6	B	8/27/23 18:25	81	8/27/23 00:00
7	D	8/27/23 09:35	78	8/27/23 00:00
8	A	8/28/23 14:33	91	8/28/23 00:00
9	C	8/28/23 08:21	89	8/28/23 00:00
10	E	8/28/23 17:53	83	8/28/23 00:00
11	G	8/28/23 07:02	77	8/28/23 00:00
Dates

Cell Formulas
Range	Formula
F5:F11	F5	=ROUNDDOWN([@[Last Used]],0)

Is there a way I can sort this table and get this result without the use of a helper column?

 

[Georgiboy]

You can do it as below but by using a formula you will still end up with a duplicate of your original table:

Book1
	A	B	C	D	E	F	G
1	Item	Last Used	Rating		Item	Last Used	Rating
2	F	27/08/2023 11:22	95		F	27/08/2023 11:22	95
3	A	28/08/2023 14:33	91		B	27/08/2023 18:25	81
4	C	28/08/2023 08:21	89		D	27/08/2023 09:35	78
5	E	28/08/2023 17:53	83		A	28/08/2023 14:33	91
6	B	27/08/2023 18:25	81		C	28/08/2023 08:21	89
7	D	27/08/2023 09:35	78		E	28/08/2023 17:53	83
8	G	28/08/2023 07:02	77		G	28/08/2023 07:02	77
Sheet1

Cell Formulas
Range	Formula
E2:G8	E2	=SORTBY(Table1,TRUNC(Table1[Last Used],0),1,Table1[Rating],-1)
Dynamic array formulas.

 

[JenniferMurphy]

You can do it as below but by using a formula you will still end up with a duplicate of your original table:

Hmmm... Interesting. I'll take a look, but I think the Power Query will be my best option. Thanks