Most valuable professional
  • Hot Topics

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel