Forum Discussion
Help Function to Return Missing/Unavailable Data
I have the following table, and on each day the user will add a new row with the site and today's date.(along the rest of the info) Every day, each of the three sites will add at least one row. I...
=MAX(IF(B:B=B2,A:A))=TODAY()Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula returns TRUE (WAHR in german Excel) if there is an entry for today and FALSE if there isn't an entry for today.