Thread: Take one sales order and compare all ship dates for that order.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default Take one sales order and compare all ship dates for that order.
=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!*


"Mudassir Ahmed" wrote:

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/tutorials...vices-usi.aspx

Reply With QuoteReply With Quote