Excel question - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Excel question

Moderator: Baseball Moderators

Excel question

Postby Broncmet724 » Fri Mar 14, 2008 11:58 am

I was going to post this in Steve-O's thread but I didn't want to hijack it

Say I have a spreasheet with 10 seperate pages for hitters and pitchers, for a total of 20. Of course none of them have the same names on each of them. Is there a way without going through each sheet individually and deleting the names you don't need to sort them on a final page to average them out?

For example some sheets start with Andy Abad, where I only care about Bobby Abreu first. So on my 11th sheet I want Bobby Abreu's avearge from the previous 10, then Garrett Atkins', and moving on down the list. I know I can go from page to page and copy the sheet and cell data into an average formula, but is there a way to do it without manually doing the formula for about 475 guys?

I've been deleteing all the names off the sheets I don't want so I could do one formula and just copy and paste. But it's really time consuming deleting names I don't want, adding names on some sheets that are missing them. I'm sure there has to be a simpler way.

Thanks
Image
Broncmet724 Beginner
Major League Manager
Major League Manager

User avatar

Posts: 1754
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

Re: Excel question

Postby RugbyD » Fri Mar 14, 2008 12:07 pm

on your averages page, just use VLOOKUP to reference a name in each of the others for only the players you want.
TennCare rocks!!!!
RugbyD
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5591
(Past Year: 4)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly


Return to General Talk

Who is online

Users browsing this forum: unioreimi and 7 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Saturday, Apr. 19
(All times are EST, weather icons show forecast for game time)

Chi Cubs at Chi Cubs
(1:05 pm)
Minnesota at Kansas City
(1:05 pm)
Cincinnati at Cincinnati
(1:08 pm)
Houston at Oakland
(1:35 pm)
Milwaukee at Pittsburgh
(2:10 pm)
NY Yankees at Tampa Bay
(2:20 pm)
indoors
Seattle at Miami
(4:05 pm)
indoors
NY Mets at NY Mets
(7:05 pm)
Atlanta at Atlanta
(7:10 pm)
Philadelphia at Colorado
(7:10 pm)
Chi White Sox at Texas
(7:10 pm)
LA Dodgers at LA Dodgers
(8:05 pm)
Arizona at Arizona
(8:10 pm)
San Diego at San Diego
(8:10 pm)
San Francisco at San Francisco
(8:40 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact