From an Excel list of event attendees spanning 10 years, how do I create another list that pulls the first year of attendance for all my attendees?
Solution 1:
Try a MINIFS formula like this.
=MINIFS(B:B,A:A,E8)
From an Excel list of event attendees spanning 10 years, how do I create another list that pulls the first year of attendance for all my attendees?
Solution 1:
Try a MINIFS formula like this.
=MINIFS(B:B,A:A,E8)