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!