I have a number in A1, A2, A3, A8, A9, and another set of numbers in C1, C2, C3, C8, C9.
I want to to find the maximum quotient from dividing the individual numbers in the second set by the corresponding numbers (for each cell) in the first set (sort of like a max of the sumproducts, but quotients).
In other words, I want max(C1/A1,C2/A2, etc.), but in my specific case the data sets are much bigger.
Thank you!
I want to to find the maximum quotient from dividing the individual numbers in the second set by the corresponding numbers (for each cell) in the first set (sort of like a max of the sumproducts, but quotients).
In other words, I want max(C1/A1,C2/A2, etc.), but in my specific case the data sets are much bigger.
Thank you!