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!
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.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
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)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks