MIN(COLLECT) with multiple criteria

Jennifer Lenander

I need to collect the earliest date on a sheet based on a company but also based on whether an employee made the contact or a consultant.

I started with: =MIN(COLLECT({Date}, {Company}, [Company]@row)) - and this worked overall, but not sure how to add in the second parameter.

This is and example of my source sheet:

And on my formula sheet I have separate columns for EE/Consultant

How do I take my original formula so that it returns a date only if an employee made the contact? I think I would =MIN(COLLECT({Date}, {Company}, [Company]@row, {Employee}, ___________)) but I'm not sure and everything I'm trying isn't working.

Would love some thoughts.

Jennifer Lenander

I figured this out!

=MIN(COLLECT({Date}, {Company}, Company@row, {Employee}, "<>"))

Works like a charm!

Jennifer Lenander

I figured this out!

=MIN(COLLECT({Date}, {Company}, Company@row, {Employee}, "<>"))

Works like a charm!