View Single Post
  #9   Spotlight this post!  
Unread 07-03-2006, 14:59
Faith's Avatar
Faith Faith is offline
Registered User
AKA: Plooshiska
FRC #1100 (The T'Hawks)
Team Role: Scout
 
Join Date: Jan 2006
Rookie Year: 2006
Location: Algonquin
Posts: 110
Faith will become famous soon enoughFaith will become famous soon enough
Re: Excel Help for Scouting Database

Quote:
Originally Posted by DjAlamose
I don’t think what is need is to see if the data is true or not, I think what is wanted is to sort the data by team on another sheet.

If this is the case then you can use filter commands. Go to data, then filter, then advanced filter. You can type in what team you want to show and it will filter out all of the unnecessary data. You should be able to preset up a sheet with the teams going to the regional and have the filters update automatically. If not then you will have to do it after the data is collected. But, you could always just sort by a certain value such as shots made into the goal in the data entry sheet. I hope this helps.
For that it says column labels are needed. I think I know how to do those, but... I have never done that before in Excel. Could you verify how?
__________________
FRC: TEAM 1100
FVC: Team 3377