i have 60,000 rows with 3 columns:
id# station result
5453 1
5453 2
5453 3
4321 1
4321 2
4321 3
there are 20 different numbers that have 3 stations each so theres 5453, 4321 and 18 others... and each has a result of 0 or 1
so this repeats itself for 60,000 rows so theres 1000 groups of 20 numbers with 3 stations each (total of 60 per group)
i hope this isnt too confusing... so what i need to do is write a macro that parses the entire list, or maybe just a group of 60 values (and id just repeat it manually), and calculates the average result for each station. the way that the results were generated sucks because it is grouped by id# and not station which would make it a lot easier...
if anyone has any clue how to get started or have any help to offer if greatly appreciate it!
id# station result
5453 1
5453 2
5453 3
4321 1
4321 2
4321 3
there are 20 different numbers that have 3 stations each so theres 5453, 4321 and 18 others... and each has a result of 0 or 1
so this repeats itself for 60,000 rows so theres 1000 groups of 20 numbers with 3 stations each (total of 60 per group)
i hope this isnt too confusing... so what i need to do is write a macro that parses the entire list, or maybe just a group of 60 values (and id just repeat it manually), and calculates the average result for each station. the way that the results were generated sucks because it is grouped by id# and not station which would make it a lot easier...
if anyone has any clue how to get started or have any help to offer if greatly appreciate it!