Sorting Help

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 ????
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distributing cell value (not text-to-columns) 7
Time Stored as Text 3
Complicated Look-Up 1
Running Balance (Debit and Credit) in Access 2007 3
Sort by placement value from left to right & adding trailing zeros for short 3
Help with time function 7
Formatting Numbers into Text or???!!! 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0

Top