If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
Register for a FREE account, and/ or Log in to avoid these ads!
Please help, I need to calculate the difference between 2 dates using multiple conditions, see attached, thank you.
Try: =IFERROR(IF(B4=$F$1,D4-INDEX($D$4:$D$392,MATCH(1,INDEX(($B$4:$B$392=$F$2)*($A$4:$A$392=A4)*($E$4:$E$392=E4),0),0)),""),"") copied down. If you don't want the 0 results to show, then format the range as Custom with Type: 0;-0;;@
Forum Rules
Bookmarks