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.

division	group name	rank or count should be
handbags	cobble hill	1
handbags	cobble hill	1
handbags	Emerson Place	2
handbags	cobble hill	1
handbags	Emerson Place	2
handbags	Emerson Place	2
handbags	Hawthorne Lane	3
handbags	cobble hill	1
handbags	Hawthorne Lane	3
slg	kitten	1
slg	kitten	1
slg	cobble hill	2
slg	kitten	1
slg	cobble hill	2

<tbody>
</tbody>

Thanks,
Noelle