Formula to give my most repeatable number in certain rows.

[LeapingLizard]

So I have this spreadsheet that I would like to be able to find the most repeatable number for each of the departments listed in column A.
I have included the spreadsheet. Will I have to layout the spreadsheet with more column by extending the with or can we have the formula calculate the way it is laid out?

Thanks in advance!

LeapingLizard

[martindwilson]

what do you mean by most repeatable? give a sample answer

[LeapingLizard]

Hi Martin,


Yes, most repeatable example would be for Department B2 paper towels and T-paper the answer would be 4 for each. So, for each department and for each product used what was the most repeatable amount supplied each day. Hope that helps!

Thanks,

LeapingLizard

[LeapingLizard]

Maybe this will help and someone else might have an idea as to what formula could I use to extrapolate this data.

Thanks Forumn,

LeapingLizard