I have two columns of data, say in column A and B. I would like to find the
maximum relative difference between the values in A1 & B1 vs. A2 and B2 vs.
A3 and B3 etc... Each column may have up to 300 entries. My simplistic way
to do this is to subtract the two numbers in a third column and then find the
max of this column. Is there another way to do this with a single formula or
function without an intermediate step such as creating the extra column?
Thanks.