Rank set of numbers order within respective Group ID in another column

I have a list of SSNs in one column, and a "Group ID" in another Column. I looking to get the "rank" of each SSN within each group (rank would be based on numbering from lowest to highest, ascending). I have been using the following formula to get the rank for SSN:

Please Login or Register  to view this content.

However, I am looking for the code to take into account getting the rank for each respective group.

Attached is an example workbook. I would need the formula starting in cell C2 and copied down to C14. Any ideas? Thanks.

Sample.xlsx

How about:

Formula:

Please Login or Register  to view this content.

BSB

Thanks all.. BadlySpelledBuoy's method was the one I was looking for...as the SSNs are suppose to be sorted sequentially, but sometimes the OCR software I use does not scan the numbers correctly into Excel and using this method, I can figure out which ones are incorrect...

Glad I could help.

Don't forget to mark the thread as SOLVED if you're happy you have your solution.

BSB