I have a very large data sheet and I need to find the max and min of various cells in a row. These cells are not contiguous, and I need to ignore zero values. If i were to simply need a min of these cells the formula would be as follows:
=MIN(D4,G4,M4,S4,Y4,AE4,AK4,AQ4,AW4,BC4,BI4)
Because this formula needs to go down the entire 800 rows of this report I can't do it by hand.
Excel 2010.
Thanks!
Bookmarks