Sorting 2 columns of names with the same 2 columns& limited rows

Closed
condogvinet
Posts
3
Registration date
Saturday January 27, 2018
Status
Member
Last seen
February 3, 2018
- Jan 28, 2018 at 06:41 PM
 Blocked Profile - Feb 5, 2018 at 04:37 PM
Hello,

I am looking for some help with an Excel Spreadsheet.

I have an Excel Spreadsheet with room for only 2 columns and 5 rows.

I am trying to sort 8 names alphabetically in those 2 columns and 5 rows.

For instance:

Column 1 has the names:
Jones
Smith
Barnes
Archer
Anderson

Column 2 has the names:
Young
Lawson
Fox

I would love to be able to set sort them quickly into the following:

Column 1
Archer
Anderson
Barnes
Fox
Jones

Column 2
Lawson
Smith
Young

It would even be better if I could set this up to be operated by 1 click.

Thank you so much in advance for any help you can offer. I would greatly appreciate it!!

1 reply

Blocked Profile
Jan 29, 2018 at 04:29 PM
Tt is this simple:

Range("A1:A1").Sort key1:=Range("A1"), _
order1:=xlDescending, Header:=xlNo


Or, highlight the column, and SORT!
0
condogvinet
Posts
3
Registration date
Saturday January 27, 2018
Status
Member
Last seen
February 3, 2018

Feb 3, 2018 at 05:40 PM
Thank you so much for helping! Do I create a Macro with the formula you described?
0
Blocked Profile
Feb 5, 2018 at 04:37 PM
Well, you can. Or, just name a procedure and call it!
0