Extracting max value from 3 columns of data in exel
My warehouse system contains length, width, and height calculations but the longest side isn't always in the correct column (length). Does anyone know how to extract the max, median, and miminum measurement across 3 columns of data?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 11, 2009 3:27 PM
UPDATED:
May 11, 2009 4:57 PM
Answer Wiki:
Length = col a
width = col b
height = col c
Put these results in the next columns
Col D - Max results =max(a2:c2)
Col E - median results =median(a2:c2)
Col F - minimum results =min(a2:c2)
Is there something more complicated about this issue?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
