I have a question about automatically ordering cells.
I have cells that show as follows
A B
1 |Cinthia 12
2 |Scot 20
3 |Mike 5
I would like to make it so these cells automatically order by highest to lowest. This number changes daily and I have been ordering them using Sort Highest to lowest. The issue is I need to do that manually every day. How can I have excel order a select number of cells keeping cells a and b together.
How I would like it to order this example
A B
1 |Scot 20
2 |Cinthia 12
3 |Mike 5
I appreciate all your help!
I have cells that show as follows
A B
1 |Cinthia 12
2 |Scot 20
3 |Mike 5
I would like to make it so these cells automatically order by highest to lowest. This number changes daily and I have been ordering them using Sort Highest to lowest. The issue is I need to do that manually every day. How can I have excel order a select number of cells keeping cells a and b together.
How I would like it to order this example
A B
1 |Scot 20
2 |Cinthia 12
3 |Mike 5
I appreciate all your help!