A pivot table should work for you. Select the data range then select Data -
Pivot Table. Follow the wizard (the defaults should be fine). Place the date
at the top and put the times (team names are conspicuiously absent from your
data) in the left column. Drag the wager and total to the center and that
should be a start. You can change the drop downs to show totals by date.
--
HTH...

Jim Thomlinson


"rowles80" wrote:


I have tried and tried and still can't come up with a way to solve my
problem... I was wondering if someone could help:

I am in a dart league and each team tracks their own scores in a
spreadsheet. All of the spreadsheets are the same and are linked to a
master spreadsheet which reports the total month scores for each team.
However I need to figure out a way to sort or display the daily
winners. Here is an example:

Team One's Spread Sheet, There are about twelve teams total (each with
thier own spreadsheet as well)

Date Game Time Wager Total
1/4/05 1:08 PM $100,000 22
1/4/05 1:17 PM $100,000 26
1/4/05 1:26 PM $500,000 31
1/4/05 2:22 PM $300,000 20
1/4/05 2:33 PM $100,000 24
1/10/05 1:50 PM $500,000 22
1/10/05 2:18 PM $100,000 22
1/10/05 2:26 PM $100,000 26
1/10/05 3:00 PM $500,000 31
1/15/05 1:28 PM $300,000 20
1/15/05 1:36 PM $100,000 24
1/15/05 1:45 PM $500,000 22


I need to take from each of the teams' spread sheets and calculate the
daily totals (for wager and totals).

Is there a way for me to lookup by the date and then display the wager
and totals that corispond to that date.

I don't know... I am out of ideas... please help!


--
rowles80
------------------------------------------------------------------------
rowles80's Profile: http://www.excelforum.com/member.php...o&userid=31268
View this thread: http://www.excelforum.com/showthread...hreadid=509370