Sorting - Interlacing

[Kreppie]

Hi,

Does excel have a possibility to interlace data in stead of sorting them the conventional way?

I mean like this;
Suppose you have data

A
B
B
A

If you sort them, they become:
A
A
B
B

but what I want is:

A
B
A
B

Any Solutions?

 

[onlyadrafter]

Hello,

Assuming your data starts in A1, in B1 enter the following formula

=COUNTIF($A$1:A1,A1)

and copy down column B as far as column A goes.

Then select columns A and B and sort by Column B first, then by Column A.

This works for the data supplied.