Extracting max value from 3 columns of data in exel
Home > IT Answers > Microsoft Windows > Extracting max value from 3 columns of data i...
JTWSGC
5 pts.
0
Q:
Extracting max value from 3 columns of data in exel
Microsoft Excel, Excel functions
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?
ASKED: May 11 2009  3:27 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Labnuke99
26290 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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?
Last Answered: May 11 2009  4:57 PM GMT by Labnuke99   26290 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0