How many times repeated number in a cell

How many times repeated number in a cell based on a condition or two

Quote:

---

Originally Posted by mahmoud-lee

How many times repeated number in a cell based on a condition or two

---

Hi,

Attached is the solved example with multiple conditions.

Please revert in case of any problem.

Regards,
Vitesh

I have attached a solution with different formulas than Vitesh posted for your consideration... just copy any row of them, within columns C thru G, down to the bottom of your data.

Basically you only need 1 type of formula:

=INT(MOD($A2;C$1)/D$1)

Fantastic Mr. Rick
You are a genius
I'm impressed with all of your business

Thank you Mr. (SNB)
Your business is also great