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.xlsx||86.87 KB|