Numbering matching instances - but not a vanilla ranking

[df9864]

Hi - I'd really appreciate some help with this as I've hit the wall.
I need to identify matching items and number them (1 to x) by category. It's much easier to show you what I mean with a table below - please excuse the food based data points - it's for example purposes only
I don't want to do any sorting and the fields are in an Excel table.

Category1 Category2 Desired result
Fruit apple Fruit1
Fruit banana Fruit1
Fruit apple Fruit2
Fruit apple Fruit3
Fruit pear Fruit1
Fruit pear Fruit2
Fruit pear Fruit3
Veg brocoli Veg1
Veg cabbage Veg1
Veg cabbage Veg2
Veg cabbage Veg3

 

[df9864]

Actually I just figured it out lol. it's a simple countif statement. Concatenating Cat1 (col A) & Cat2 (col B) into column C, it would be the following
= A2 & COUNTIF($C$2:C2,C2)

I'll give myself a pat on the back!!

 

[mikerickson]

No need for a helper column

=A1&COUNTIFS($A$1:$A1,A1,$B$1:$B1,B1)

should do it