need help

hello friends,

was struggling with an excel formula and finally found this site after googling. Hope to get help here.

i need to identify the number of transactions instead of number of equipment based on the column B.
For example, from rows 8 to 10, i want a formula at Col H to indicate that it is ONE entity instead of THREE based on the condition of Row B and Row C having the same data. An unique running number will be cool too :-)

excel help.xlsx86.87 KB

count unique strings with condition


in H2 to be confirmed with control+shift+enter before copied down:


Hope it helps