Lookup Latest Date Using Multiple Criteria

**maggioant** · 01-25-2010, 08:13 PM

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!

**teylyn** · 01-25-2010, 08:36 PM

Hi, without seeing your actual data setup it's a bit hard to write a formula, but something along the lines of

=MAX(($A$1:$A$100="Category X")*$C1:$C$100)

this needs to be entered with Ctr-Shift-Enter

format result as date.

**DonkeyOte** · 01-26-2010, 04:32 AM

Just to add to Teylyn's post.

If you want to return dates for multiple categories you might be best served creating a Pivot Table with Category as Row Label and Date Scheduled as Data Field set to MAX (formatted as Date)