Link to home
Start Free TrialLog in
Avatar of vegas86
vegas86

asked on

Excel Count Formula

Hello,

I have attached an example of what I am looking for as I am having trouble finding an answer on google. I need a formula that counts based on column A the number of differenent occurences in column B that displays in column C in numerical order, so if the number changes in column A the number restarts at 1 in column C.

I am really sorry that I can't explain this, I have confused myself too much with this.

I assume it is going to be a countif formula but can not work it out, any help on this will be greatly appreciated.
File.xlsx
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Sorry - I'm confused - you are going to have to clarify exactly what you want
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vegas86
vegas86

ASKER

Thank you, thank you, thank you! I can't say it enough! THANK YOU SSAQIBH! You have just made my day! :)