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 :-)

AttachmentSize
excel help.xlsx86.87 KB

count unique strings with condition

Hi,

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

=SUM(IF(FREQUENCY(IF($B$2:$B$100=B2,MATCH("~"&$C$2:$C$100,$C$2:$C$100&"",0)),ROW($A$2:$A$100)-ROW($A$2)+1),1))

Hope it helps