I have a list of workshops scheduled and I need to write a function that returns the latest date within each category of workshop. I tried using an "If" statement with a nested "MAX" but I haven't been able to get it to work.

The current spreadsheet has three columns: Category, Workshop Name, Date Scheduled.

The output sheet should have two columns: Category, Latest Date Scheduled

Any ideas? Thanks!