My table consists of accounts with the same name, date received, dated
needed, etc. Also, there can be multiple rows with the same account name and
date received.

the table list the following 2 accounts: Test1 and Test 2 once each week
throughout the table. Id like those following rows, Test1 and Test2, sorted
at the end of each week, with the Test1 row above the Test2 row.

Column (A) Column (B)
Paddock 11/3
Crestview 11/4
High Park 11/5
Test1 11/8 - Desired Output
Test2 11/9 - Desired Output
River Cons 11/10
Crestview 11/11
High Park 11/13
Test1 11/15 - Desired Output
Test2 11/16 - Desired Output

Regards,