# Posts by AcctgController

• ## # of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s

Again - thanks for the laugh! You eased my frustration level.

When you used that formula, did you get the result of 9? I cut-n-pasted that formula into cell E2 and got 1. So I dragged the formula down to E26 - got 1's on all orders shipped on 3/4 and #VALUE! on all orders shipped on 3/1. So I added up the 1's and got 14. That's the same result my COUNTIF formula was giving me. I'm trying to get a formula that will spit me out the correct answer of 9 for this example. There are 9 unique order numbers from the list that shipped out on 3/4.

• ## # of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s

Funny! Very funny! SMH HAHAHAHAHA

• ## # of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s

I'm trying to create a formula that will tell me the number of orders that shipped after the order date. I was able to find a formula that spit out for me that there are 14 rows greater than 3/1/2019 but I need it to spit out that there are actually just 9 orders that are greater than B2 due to the duplicate order numbers in Column A. Anybody able to help? I don't know the right questions to ask Google to help me formulate this complicated calculation.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

[tr]

[TD="width: 84"]Order Nbr[/TD]
[TD="width: 90"]Order Date[/TD]
[TD="width: 132"]Ship Date[/TD]

[/tr]

[tr]

[td]

1647844

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:21[/TD]

[/tr]

[tr]

[td]

1647844

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:21[/TD]

[/tr]

[tr]

[td]

1648106

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:03[/TD]

[/tr]

[tr]

[td]

1648067

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:01[/TD]

[/tr]

[tr]

[td]

1648067

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:01[/TD]

[/tr]

[tr]

[td]

1648067

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:01[/TD]

[/tr]

[tr]

[td]

1648028

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 9:59[/TD]

[/tr]

[tr]

[td]

1648003

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:06[/TD]

[/tr]

[tr]

[td]

1648003

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:06[/TD]

[/tr]

[tr]

[td]

1647930

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:14[/TD]

[/tr]

[tr]

[td]

1647919

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:23[/TD]

[/tr]

[tr]

[td]

1647919

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:23[/TD]

[/tr]

[tr]

[td]

1647830

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:18[/TD]

[/tr]

[tr]

[td]

1647815

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/4/19 10:11[/TD]

[/tr]

[tr]

[td]

1647670

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:18[/TD]

[/tr]

[tr]

[td]

1647669

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:20[/TD]

[/tr]

[tr]

[td]

1647655

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:21[/TD]

[/tr]

[tr]

[td]

1647624

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:24[/TD]

[/tr]

[tr]

[td]

1647624

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:24[/TD]

[/tr]

[tr]

[td]

1647593

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:25[/TD]

[/tr]

[tr]

[td]

1647575

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:17[/TD]

[/tr]

[tr]

[td]

1647573

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:27[/TD]

[/tr]

[tr]

[td]

1647566

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:29[/TD]

[/tr]

[tr]

[td]

1647537

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:30[/TD]

[/tr]

[tr]

[td]

1647498

[/td]

[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/1/19 15:28[/TD]

[/tr]

[/TABLE]