Work out Mode for a table of numbers that needs to be divided.

[blc123]

I need to find the Mode for a table of numbers that needs to be divided by another set of numbers.

For example:

B1, C1, D1 needs to be divided by G1, H1, I1 and retrospective for all other rows in the table. How do I find the mode of these numbers and divide them at the same time?

Also, some of the data in the table is blank, is there a way to override this, so the end result doesn't always come up with an error or #Div?

Thanks

[vba_php]

there are count functions in excel:

https://www.google.com/search?q=ms+e...ount+functions

https://support.microsoft.com/en-us/...4-d23bf411294c

furthermore, the mode has a definition, and I'm sure you've got that part down already.

https://en.wikipedia.org/wiki/Mode_(statistics)