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 :-)
| Attachment | Size |
|---|---|
| excel help.xlsx | 86.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