Older versions of Excel need this entered with
This searches your data for the row where the ID meets the criteria (in this example I used
G22 for the ID to match).
Aggregate checks for a non-empty cell in that range and returns the value in the header. EOMONTH then returns the last day of that month.
If there’s no values or matching ID’s it returns as blank.
CLICK HERE to find out more related problems solutions.