Forum Discussion
Choose MAX date from several columns, based on TODAY's DATE
Hi everyone, Outcome is to report which 'Stage' an account was, at a certain point in time. For example, in table below, the Stage column (currently showing what result should be), needs to be a ...
Just one thing!
"except for your column "Admissions File Pending" which you give as the "Stage" for a couple of entries, even though it's NOT the max date in the row." - that's because i want to know the stage as of 03/06/2019 for rows where intake = 2019.2 and as of 03/06/2020 for rows where intake = 2020.2
XMATCH (and XLOOKUP) are quite new. They've been available to the "insiders" for some time, but to the rest of us ordinary people (subscribers to Microsoft 365) quite recently.
Also try to acquaint yourself with the Dynamic Array functions. FILTER, SORT, UNIQUE, etc A LOT of power in these.