Check for Duplicates, Compare Dates of Duplicate Rows, Display Date Furthest in the Future

Stefanie S.

Hello,

I have a sheet where I'm in-taking data from grad students signing up for access to lab rooms. They provide us with their begin and end dates. Sometimes they will resubmit the form when their end date changes and they're at the university longer.

I've made a helper column called Duplicates that checks a box when there are duplicates of the Identifier but I'm having trouble getting to the next step which is displaying the End Date in a new column that is the furthest in the future of a duplicate row.

Thank you,

Stefanie

SJ Sellers

Use MAX(COLLECT(get your dates for the identifier))