How to match collect an list based on role

Bruce Johnson

I have a sheet one column is role which has for example Project Managers, Network Engineers, Database Engineers performing tasks throughout the sheet. I have a start and end column for each task - I want to collect the start and end date based on role - what is the earliest date, latest date for each role.

Bruce Johnson

nevermind - simpler than I thought. Max or Min is date column and collect is Role column. Brain damage on my part trying to make it more complicated than it needed to be.

Bruce Johnson

nevermind - simpler than I thought. Max or Min is date column and collect is Role column. Brain damage on my part trying to make it more complicated than it needed to be.