View Single Post
Old 01-17-2008, 11:26 AM   #8
R4ND0M_AX3
Scooby Newbie
 
Member#: 67483
Join Date: Aug 2004
Location: Sacramento, CA
Vehicle:
2005 WRX STi

Default

excel 2007 has some new functions that will do the selection for you. You can define the conditions from adjacent cells.

I used to do the same you did manually. Then figured it out. I used AVERAGEIF and COUNTIF (gives me the number of samples that I'm using for the average). I'll have to see if there is a MODEIF to expose the most common value (didn't know about mode until this thread).

I also have it figure out the cell breaks by puting in the break points from my map.
* Registered users of the site do not see these ads.
R4ND0M_AX3 is offline   Reply With Quote