How many times repeated number in a cell

[mahmoud-lee]

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

[vitesh]

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

[Rick Rothstein]

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.

[snb]

Basically you only need 1 type of formula:

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

[mahmoud-lee]

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

[mahmoud-lee]

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