Take one sales order and compare all ship dates for that order.

Take one sales order and compare all ship dates for that order.

Post by Mudassir » Wed, 23 Sep 2009 03:00:58


Hello

I am pulling my hair for a solution for this problem.

I have a data sheet with information on ship-dates for each ship-to address.

Each ship-to address has several Sales order. And each sales order has either same or different ship-dates based on workorder status.

I need to somehow be able to flag any sales order that is being shipped to the same ship to location within a difference of 3 days.

How do I do this?


Data:

Address Ship Date Sales Order #
12342 9/21/2009 6192149
12342 9/19/2009 6192149
12342 9/24/2009 6192149


EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.yqcomputer.com/
 
 
 

Take one sales order and compare all ship dates for that order.

Post by THVrZSB » Wed, 23 Sep 2009 03:28:03

=IF(SUMPRODUCT(--(A$2:A$100=$C$2),--(B$2:B$100>=$D$2-3),--(B$2:B$100<=$D$2+3))>1,"Flagged","")

Replace C2 and D2 with the actual references to the cells with the data you
want to check (address and ship date, respectively). Then copy the formula
down.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*