Hi:

I am unable to upload an excel file.... lets consider the below in a spreadsheet.

I am seeking help for my current issue. If the following applies then flag column D.

If the "Work Ctr" is RNDCL has greater than 4 orders in the same week then flag in column D with a Yes. Less than 4 per week then "NO"

There cannot be more than 1 order number in a given week.

Many of these have duplicates and need to be excluded. I have a mass amount of data like this so I can't simply remove the duplicates but need it to automatically include no more than 1 specific order per week.

Columns should be

A) Order Number
B) Work Ctr
C) Finish Week (Date)
D) New Column


Order Number Work ctr Finish Week (Date)[/B] New Column(D)
3005687115-40 RNDCL 1/29/2016
3005687115-20 RNDCL 2/5/2016
3005687115-20 RNDCL 2/5/2016
3005687115-20 RNDCL 2/5/2016
3005687115-30 RNDCL 1/29/2016
3005687115-30 RNDCL 1/29/2016
3005687115-30 RNDCL 1/29/2016
3005687115-40 RNDCL 1/29/2016
3005687115-40 RNDCL 1/29/2016
3005687115-40 RNDCL 1/29/2016
3005744429-10 RNDCL 1/29/2016
3005744429-20 RNDCL 1/29/2016
3005744429-10 RNDCL 2/12/2016
3005744429-10 RNDCL 2/12/2016
3005744429-10 RNDCL 2/12/2016
3005744429-20 RNDCL 2/12/2016
3005744429-20 RNDCL 2/12/2016
3005744429-20 RNDCL 2/12/2016
3005753341-10 RNDCL 2/26/2016
3005753341-20 RNDCL 3/4/2016
3005729844-10 RNDCL 2/26/2016
3005747247-20 RNDCL 3/11/2016
3005753341-10 RNDCL 3/4/2016
3005753341-10 RNDCL 3/4/2016
3005753341-10 RNDCL 3/4/2016
3005753341-20 RNDCL 3/4/2016
3005753341-20 RNDCL 3/4/2016
3005753341-20 RNDCL 3/4/2016
3005729844-10 RNDCL 3/11/2016
3005729844-10 RNDCL 3/11/2016
3005729844-10 RNDCL 3/11/2016
3005747247-20 RNDCL 3/11/2016
3005747247-20 RNDCL 3/11/2016
3005747247-20 RNDCL 3/11/2016
3005768234-10 RNDCL 3/18/2016
3005768234-10 RNDCL 3/31/2016
3005768234-10 RNDCL 3/31/2016
3005768234-10 RNDCL 3/31/2016