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
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
Sorry - I'm confused - you are going to have to clarify exactly what you want
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, thank you, thank you! I can't say it enough! THANK YOU SSAQIBH! You have just made my day! :)