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

[Mudassir Ahmed]

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.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx

 

[Luke M]

=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.