Excel LARGE and EOMONTH Array Function
I’m working on a dashboard for a client and I’ve set it up so that they can choose which month they want to display in their report. When they choose a new month the header in the report automatically updates to show the new 'From' and 'To' dates. New data is added daily, so at …