Music Banter - View Single Post - Excel problem - Can anyone help me?
View Single Post
Old 04-22-2009, 06:01 AM   #3 (permalink)
Guybrush
Juicious Maximus III
 
Guybrush's Avatar
 
Join Date: Nov 2008
Location: Scabb Island
Posts: 6,525
Default

Quote:
Originally Posted by Thrice View Post
Can you please explain why your method wont work? I might be missing something, but can you not just =AVERAGE(B2:B288) like you did, also for MIN and MAX, but only have to do it 90 times?
Yes, I could do that .. It's just that it's so horribly labour intensive, I want to find a way to automate this process. Otherwise, it's gonna take me hours and hours.

This may look like it's something I "only" have to do 90 times, but there's many more columns so we're talking about several hundreds

edit :

The raw data set is here by the way -> sv
__________________
Something Completely Different
Guybrush is offline   Reply With Quote