Count Duplicates in column

Hello all,

I have a feeling a solution to this will require VBA but I don't know much at all about VBA so hopefully I'm wrong. So I have a column with something like 20 thousand rows. I would like a formula that basically checks the column for duplicates and numbers the sets of duplicates. So if there are 5 cells that are all "Server10" I would like for the formula to place a one next to all of those cells. And for the next set of duplicates it finds I would for it to place a 2 next to all of those cells. Essentially my end goal is to sort the sheet so that all of the matching duplicates are all together. There might be some simple filtering method here that I'm overlooking but if there is..... I'm overlooking it lol. And to be clear I don't want to eliminate the duplicates, I just want them grouped together.

I've attached a very simple example of what I would like the formula to do. The cells in the right column would be the result of the formula.

Thanks in advance for any advice provided,

SomeDude0nline

Suppose your data in column "a2" & "b2"
In column "c2" both columns merge with formula:

HTML Code: 

In column "d2" type formula: (if ans is "true" means duplicate)

HTML Code: 

For find out how many dupplicate value formula is:

HTML Code: 

Hope your problem solved.
If you satisfy with solution plz add reputation.

Glenn,

Wow, I feel really stupid right now. I was about to respond saying something like "thanks but the data isn't quite as simple as the example" but then I realized probably what you were too nice to say: I'm an idiot and if it's a duplicate then sorting alphabetically will group the duplicates together lol.

Sorry for my ignorance, I guess I was overlooking something simple.

Thanks again for the input,

SomeDude0nline