Ranking Text using Multiple Text Criteria

[noellerbe]

Hello,

I have data that I would like to assign a number (or rank) for each group within a division. Data is not grouped together, and I do not want to sort data. I am seeking the below result, but I cannot figure out what formula to use. Please help! Table starting at A1.

[TABLE="class: outer_border, width: 350"]
<tbody>[TR]
[TD]division[/TD]
[TD]group name[/TD]
[TD]rank or count should be[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]cobble hill[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]cobble hill[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]Emerson Place[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]cobble hill[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]Emerson Place[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]Emerson Place[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]Hawthorne Lane[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]cobble hill[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]handbags[/TD]
[TD]Hawthorne Lane[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]slg[/TD]
[TD]kitten[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]slg[/TD]
[TD]kitten[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]slg[/TD]
[TD]cobble hill[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]slg[/TD]
[TD]kitten[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]slg[/TD]
[TD]cobble hill[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
Noelle