Hi. I've got a fairly large dataset. Most of the records are in a 'Closed' state, and I'm trying to find the the oldest date where a record is still showing 'Pending Completion'. If I use the formula to find the earliest Closed date, it works (of course, that's also the oldest record in the dataset). But when I use the formula to find the oldest date for 'Pending Completion', I get #N/A. There are definitely plenty of records still at Pending Completion. Thank you for any advice.
Works
=MINIFS($G1:$G77719,$N1:$N77719,"Closed")
Doesn't work
=MINIFS($G1:$G77719,$N1:$N77719,"Pending Completion")
Bookmarks