Excel: Finding the maximum of quotients of two non-contiguous cell groups...


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!


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of June 01, 2015.


For more resources for Microsoft Excel