Hi Chris -

1. Is the WeekEnding supposed to be based on the PotentialDate or the
ArrivalDate ?

2. What day of the week defines your week ending dates (Sat, Sun, Fri, etc.)?

--
Jay


"Chris" wrote:

Good Evening,

I am having difficulty writing an If statement on my spreadsheet. What
I did was I have 2 spreadsheets that the first one has a master lister
of data. It is sorted by the following:
Sheet #1 has the following
Date, File Number, "Orgin", Name, Number of QTY

What I am trying to do is to create I think If statements and counts to
pull this data from date ranges and list is out on a second excel
spreadsheet. Idealy this is what I want to accomplish.

Sheet #2

Week Ending
October 8th
Orgin and date are the key becasue I want it sorted by this.

A count of the files in the date range (Say Oct 1st - Oct 8th) filter
out duplicates) then the same for say Oct 9th-Oct 16th, Oct 17th-23rd
and so on. 2 packets of results for each orgin A & B.

Same for a count of the names in that period of time. Now I don't need
to eliminate duplicates for the names becuase some files have multiple
names

An add of the number of qty.

So I am trying to get my output to look like this.

Week ending
October 8th
Orgin:A (its either going to be orgin A or B
Number of files: 10 count without duplicates)
Number of names: 15 (count with duplicates)
Number of QTY 123 (sum)

October 8th

Orgin B
Number of files: 12
number of names 20
number of QTY 150

October 15 (same format as the 8th and so on)

Orgin A:

If anyone knows how I can even get started on this, I would be very
greatful. I have read alot on the IF statement, Count, DCOUNT and I am
getting lost!!!!!