Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 05-19-2017, 12:18 PM   #192
swordo84
. .
 
swordo84's Avatar
 
Join Date: May 2002
Location: Canada
Posts: 15,963

Shows Seen: 12

DMB Hub Stubs: 7

My Tour Central Stats

Re: Excel Help

Quote:
Originally Posted by rconverse View Post
You can but he'd have way too many iterations to get up to 4,456. It takes 149 intervals to get to 4,456 in groups of 30.



You're going to need to use a pivot table. It's really not difficult.

I'm going to assume your data is set up in a traditional spreadsheet format.

Select cell A1 in that worksheet.
Go to Insert and then click on pivot table (It's just under and to the left of the Insert tab of the ribbon)
A new little screen will appear - just click on okay
That will create a new worksheet (don't worry, nothing happens to the old worksheet. it's still fine)
You will see a menu on the right that says Pivot Table Fields
Select the column with your number and drag it down to the box where it says "rows"
Select the column again and drag it to where it says "values"

You will see the pivot table start to the build on your left.

There should be two columns in your pivot table...

Row Labels & Sum of (Whatever is the name of your column)

Right click on the Row Labels column and select "Group" and enter
Starting at 1
Ending at 5000
By 30

Right Click on "Sum of (Whatever is the name of your column)"
Summarize values by - Count

You're done.

Ok, great - thanks for the help. I'm about the leave for the weekend so this is now a Tuesday project (yay for Canadian long weekends!)

If I still have troubles on Tuesday I'll reach out - thanks again!
swordo84 is offline   Reply With Quote