We have a gaming league at our store and I'd like to display the top scorers for a certain time period in a separate sheet.
My first sheet in the workbook pulls data from an online submission form. It looks like this:
Timestamp 4 Digits Last Name Kills Deaths
12/20/2012 23:48:35 6464 DUNNIGAN 32 12
12/20/2012 23:48:54 6464 DUNNIGAN 18 2
12/20/2012 23:49:06 1234 WATT 27 4
12/20/2012 23:49:19 1234 WATT 31 20
12/20/2012 23:49:34 4321 BURTON 12 1
12/20/2012 23:49:48 4321 BURTON 34 16
On the second sheet I need to show only submissions that happened today, but I also need to combine duplicate names and add scores together. The sheet will also need to display by most to least kills. So it will need to look like this:
1234 WATT 58 24
6464 DUNNIGAN 50 14
4321 BURTON 46 17
The third sheet will do the same thing but in the timestamp range of the last 7 days.
The fourth sheet, the last 30 days.
The fifth sheet, of all time.
I've tried for many hours to piece together the formulas myself and I just can't make it happen, HELP!
Bookmarks