Forum Discussion
Solved
Display cell information based on cell with lowest date and another cell with the word Open.
Hello all, I am sure this is an easy formula, but it is escaping me... I have a spreadsheet which is used to track open assignments. Each row displays assignment number, Date opened, date clo...
=INDEX(A2:A1500,MATCH(1,(D2:D1500=MIN(IF(G2:G1500="Open",D2:D1500)))*(G2:G1500="Open"),FALSE))
Remember, confirm with Ctrl+Shift+Enter if you're not on Microsoft 365 or Office 2021.
Sorry, would help to know which Column goes with which data set.
Assignment number = column A
Date Opened = column D
Date Closed = column E
Status = column G
DD
Assignment number = column A
Date Opened = column D
Date Closed = column E
Status = column G
DD
=INDEX(A2:A1500,MATCH(1,(D2:D1500=MIN(IF(G2:G1500="Open",D2:D1500)))*(G2:G1500="Open"),FALSE))
Remember, confirm with Ctrl+Shift+Enter if you're not on Microsoft 365 or Office 2021.
- Thank you Hans, that was it, worked perfect.