wayneeustace
New Member
- Joined
- May 16, 2015
- Messages
- 22
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
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