Sorting Help

  • Thread starter Thread starter klafert
  • Start date Start date
K

klafert

I have column A that has Account ID number and there are three sections. The
I want to sort so that I have each section in order. In other words - see
example below.

Current Sort Desired Sort

Acct. ID. Acct. ID.
4100-1-01 4100-1-01
4100-1-01 4120-1-01
4100-1-01 4130-1-01
4120-1-01 4100-1-01
4120-1-01 4120-1-01
4120-1-01 4130-1-01
4130-1-01 4100-1-01
4130-1-01 4120-1-01
4130-1-01 4130-1-01

How can I sort The Current sort to look like Desired Sort??? Can't use Data
Sort or ????
 
Insert a helper column, and input this formula, copied down:
=COUNTIF(A$2:A2,A2)

Then, select your data, go to Data - Sort. Sort by helper column first
(ascending) then by your account no.
 
Back
Top