For your 2nd "tricky" question,
viz: .. I want to sort the range in an "ABCD" format

This set-up reads the automated alpha sort results derived earlier in cols D
and E
(as per my response to your 1st question)

You could place this in F1:
=INDEX(D:D,MOD(ROWS($1:1)-1,4)*3+1+INT((ROWS($1:1)-1)/4))
Copy F1 to G1, fill down to return the desired "ABCD" results, viz:

Name2 A
Name4 B
Name1 C
Name3 D
Name6 A
Name11 B
Name7 C
Name5 D
Name8 A
Name12 B
Name9 C
Name10 D

Success? Celebrate it, click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Scott" wrote:
I have a column (Column A) of text data in one column with anywhere between 1
and 144 rows of unique text data. Next, in Column B, I have another series
of text data with the same amount of rows, but contains duplicate text fields.

In Column C, I want to sort the data in Column B and return the associated
data in Column A. For one more trick, see below...

For example:

---A------B---
Name1___C
Name2___A
Name3___D
Name4___B
Name5___D
Name6___A
Name7___C
Name8___A
Name9___C
Name10__D
Name11__B
Name12__B

Now in Columns C and D I want the output to be:
---C------D
Name2___A
Name6___A
Name8___A
Name4___B
Name11__B
Name12__B
Name1___C
Name7___C
Name9___C
Name3___D
Name5___D
Name10__D

Now, finally, here's the tricky one. In Columns E and F, I want to sort the
range in an "ABCD" format. Like so:

E---F---
Name2___A
Name4___B
Name1___C
Name3___D

And so on...

What do I use to return this?

Thanks!