Most occurrences in specific date ranges

[audiofreak]

Hi!

After getting great help from my first question in this forum, I wanted to ask you for some more. I am new to formula building in Excel, and have a basic knowledge of Excel. I'd like to get data for the most occurrences in specific date ranges. Like, most sold in one month....most sold in one week...most sold in 24 hours....most sold in one year... and have that information reported for each seller on worksheet 2.

Here is an example of what I am trying to do:

Worksheet 1 covers over 400 rows of sales covering just over a year:

A1 = Date B1 = Time C1 = Seller Name

A2 = 4/10/12 B2 = 2:00 pm C2 = John Doe
A3 = 5/11/12 B3 = 11:15 AM C3 = John Doe
A4 = 5/12/12 B4 = 12:20 PM C4 = John Doe
A5 = 6/19/12 B5 = 2:15 pm C5 = Jane Dee
and so own down


On worksheet 2 I'd like to have the info show something like this:

A1 = Seller Name D1 = Most in one day E1 = Most in one week F1 = Most in one month G1 = Most in one year


I have other data on other columns that's also tabulated from worksheet 1.

It feels like it may be complicated...so I am open to your thoughts on the best way to get the info and represent it in my worksheets.

I'm using Excel 2008 and on iMac.

I hope this makes sense!

Thank you so much for reading this...I look forward to your suggestions!

[oeldere]

You get better help if you post an example of your workbook, without confidential information.

[audiofreak]

I should also clarify about date ranges that concern one week, one month, and one year.

For the week, I'd like to keep track of the most sales of each seller in any one calendar week Sun-Sat and have that number generated on worksheet 2.

For the month, the same thing. The most sales the seller has done in any one month, and have that number be generated on worksheet 2.

For the year, I'd follow the calendar year. So, it'd be the most sales the individual seller has done in any one calendar year. Because my list started in 2011, this won't be much until a few years from now, but I'd like to get it started.


Example.xlsb

Does this help? Here is an example of worksheet 1 (called "example")... and also what worksheet two would end up being.
Wksheet 2 sample.xlsx

I hope this makes sense and clarifies things!

Thank you!!

[oeldere]

maybe with an pivot table?

[audiofreak]

Thanks! I'll give it a try. I was hoping to keep it all on two worksheets...but I'll play with this. Thanks!