Snake Eyes
Board Regular
- Joined
- Dec 14, 2010
- Messages
- 103
- Office Version
- 365
- 2016
- Platform
- Windows
I have cell F93 that has the following code.
The intention is to display the date from a cell in the range of F28:F82 that contains the most recent (date) entry.
For example, if F37 contains 2-15-23, F43 contains 1-5-23 and F81 contains 3-1-23, cell F93 should display 3-1-23.
In other words, F93 should display the contents of the last cell with any value within F18:F82 regardless of the contents of any cell above that last cell displaying data.
My issue is that I have 6 cells in that range that have the same formula (see below.) These cells prevent the formula in F93 from displaying the contents of a cell in the range.
For example, F81 contains 3-1-23 and F30, F40, F50, F60, F70, F80 contain the formula below.
F93 is blank.
If I clear the formula from the 6 cells within F28:F82,
F93 displays 3-1-23.
How do I modify my formula in F93 to resolve this?
In case it matters, this formula is in 6 cells with the range F28:F82
Thank you.
Excel Formula:
=IFERROR(LOOKUP(2,1/(F28:F82<>0),F28:F82),"")
For example, if F37 contains 2-15-23, F43 contains 1-5-23 and F81 contains 3-1-23, cell F93 should display 3-1-23.
In other words, F93 should display the contents of the last cell with any value within F18:F82 regardless of the contents of any cell above that last cell displaying data.
My issue is that I have 6 cells in that range that have the same formula (see below.) These cells prevent the formula in F93 from displaying the contents of a cell in the range.
For example, F81 contains 3-1-23 and F30, F40, F50, F60, F70, F80 contain the formula below.
F93 is blank.
If I clear the formula from the 6 cells within F28:F82,
F93 displays 3-1-23.
How do I modify my formula in F93 to resolve this?
In case it matters, this formula is in 6 cells with the range F28:F82
Excel Formula:
=IF(AND(E55="",E56<>"",F55=""),"Expiration Date ?",IF(AND(E55="",E56="",F55=""),"",IF(AND(E55="",F55<>"",E56<>""),"Original Expiration",IF(AND(E55="",F55<>""),"Expiration Date",IF(AND(E55<>"",E56<>"",F55=""),"Expiration Date ?",IF(AND(E55<>"",F55=""),"Expiration Date",IF(AND(E55<>"",F55<>"",E56<>""),"Original Expiration",IF(AND(E55<>"",F55<>"",E56=""),"Expiration Date",IF(AND(E55<>"",F55<>""),"")))))))))
Thank you.