Excel: formula help - smallest value excluding blank spaces


Hi I have a row of data that has some blank cells (each column represents a year and for some years there was no recorded value). I need to find the lowest value for the past 2 years where an entry has been recorded. Example: Column A(2015) Column B(2014) Column C(2013) Column D(2012) Row 1 500 blank 450 300 The formula needs to return the answer of 450 because it is the smallest value from the last 2 years where an entry was recorded. Is there a fix for this ? Additionally, I would need to copy the formula down to the rest of the rows beneath it that have different combinations of values and blank cells. Any assistance greatly appreciated :)


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

This thread is current as of October 11, 2015.


For more resources for Microsoft Excel