vendredi 5 mai 2017

Excel Formula using Index/Match

I'm working with an activity log of orders. My goal is to find the number of orders that were denied, then eventually released. A order was denied if the remark starts with "D", any other remark is a release.

If Remark starts with "D" Match order # in Table with Date greater than Date of "D" remark, return date of release.

This is the formula I'm using but I'm missing the date logic, it is returning the first order # match.

=SUM(IF(LEFT(C13,1)="D",INDEX($A$2:$E$2305,MATCH(E13,$E$2:$E$2305,0),4),1))

enter image description here

Aucun commentaire:

Enregistrer un commentaire