custom row sorting

[MP]

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. I’d 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,

 

[FSt1]

hi
custom sorts are usually done with a helper column.
you could add a column and assign numbers to your accounts in the order in
which you want them sorted then sort by the helper column as primary sort.
you could use another column(or 2) in your data as secondary sorts.

Regards
FSt1

 

[MP]

Thanks for the insight

How can I adjust the following code to acheive the Test 1 and Test 2 at the
end of each week and then sort the table by date received (column C)

=COUNTIF(A:A,A2) ??

 

[FSt1]

hi
not sure how this comes into play. where will you have the formula?
=countif(A:A,"Test1")
=countif(A:A,"Test2")

as to the sort, i think that may take us back to the helper column.
post back with more details if i'm confused.

Regards
FSt1

 

[MP]

my thinking was to add those formulas into the 2 columns and then I sorted
the table by
1) date received
2) column D test 1
3) column E test 2 in desending orde.

However the above method may not help when adding more data to the table.

Please provide an example using helper columns.

Thank you for your time and assistance.

 

[FSt1]

hi
test1 in column d and test2 in column e was not part of your original situp
which is confusing me more.
if you use formula, that would be a helper column but to illistrate what i
was thinking.. here is your original data with a helper column.......
Column (A) Column (B) columnC(helper)
Paddock 3-Nov 5
Crestview 4-Nov 3
High Park 5-Nov 4
Test1 11/8 - Desired Output 1
Test2 11/9 - Desired Output 2
River Cons 10-Nov 6
Crestview 11-Nov 3
High Park 13-Nov 4
Test1 11/15 - Desired Output 1
Test2 11/16 - Desired Output 2

here is sorted by helper by column b
Column (A) Column (B) columnC(helper)
Test1 8-Nov 1
Test1 15-Nov 1
Test2 9-Nov 2
Test2 16-Nov 2
Crestview 4-Nov 3
Crestview 11-Nov 3
High Park 5-Nov 4
High Park 13-Nov 4
Paddock 3-Nov 5
River Cons 10-Nov 6

regards
FSt1

 

[MP]

Yes.. thanks for the illustration and sorry if the info I provide earlier was
alittle vague.

Now how to code so the helper Column C will automically update
when new rows of data are entered into the table.

Regards,

MP