Excel Help - Fantasy Baseball Cafe 2015 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Beginner's Forum

Excel Help

Excel Help

Postby rascal7298 » Sat Mar 17, 2012 3:45 pm

If I have two different rankings, and want to compare the rankings on a singular sheet how do I do that?

For example:

Sheet A has these players ranked 1-7
Miguel Cabrera
Matt Kemp
Albert Pujols
Ryan Braun
Troy Tulowitzki
Jose Bautista
Joey Votto

Sheet B has these players ranked 1-7
Miguel Cabrera
Albert Pujols
Matt Kemp
Ryan Braun
Troy Tulowitzki
Jose Bautista
Robinson Cano

How do I incorporate the list from B onto A (similar to this)?
Column A, Column B, Column C
Kemp, 2, 3

I've been trying all morning and can't figure it out. Thanks for any help!
rascal7298
Softball Supervisor
Softball Supervisor


Posts: 45
Joined: 2 Apr 2011
Home Cafe: Baseball

Re: Excel Help

Postby GiantsFan14 » Sat Mar 17, 2012 4:15 pm

put numbers 1-7 in the cell next to each list. sort each two column list (name, number) by name so that the names in each list line up. you'll be left with something like "Kemp|2|Kemp|3", then just delete column with the second list of names.

hope that makes sense.
Image
25
@FBC_GiantsFan14 on Twitter
GiantsFan14
Baseball Scribe
Baseball Scribe

User avatar
EditorCafeholicResponse TeamCafe WriterGraphics ExpertMock(ing) DrafterWeb SupporterPick 3 Weekly Winner
Posts: 14142
(Past Year: 427)
Joined: 12 Mar 2006
Home Cafe: Baseball
Location: BUSTER HATH ARRIVED

Re: Excel Help

Postby jefferey13 » Tue Mar 20, 2012 10:19 pm

Just make sure each list has the exact same players or this will give you headache.
Image
jefferey13
Minor League Mentor
Minor League Mentor

User avatar

Posts: 778
Joined: 13 Mar 2012
Home Cafe: Baseball


Return to Beginner's Forum

Who is online

Users browsing this forum: No registered users and 0 guests

Forums Articles & Tips Sleepers Rankings Leagues


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