Previous Topic Next Topic

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

Closed
condogvinet Posts 2 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!!
Related:

1 response

Answer 1 / 1
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 2 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