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.
Hello Sergei,
Thank you as well, yours worked too!
To all who reach this thread, looking for the same output. Either of the provided formulas work!
Again thank you both for the quick response.
Thank you as well, yours worked too!
To all who reach this thread, looking for the same output. Either of the provided formulas work!
Again thank you both for the quick response.
Darkdata , you are welcome