Anybody here who can help me produce a formula that can get the earliest date in a given range with two criteria? I've attached for your reference.
Anybody here who can help me produce a formula that can get the earliest date in a given range with two criteria? I've attached for your reference.
Set your dates to be Excel date format then
=MIN(IF((I5=$A$4:$A$12)*(H5=$D$4:$D$12),$C$4:$C$12))
Enter with Ctrl+Shift+Enter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks