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![]()
Bookmarks