I am a newbie when it comes to Excel, please help... - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

I am a newbie when it comes to Excel, please help...

Moderator: Baseball Moderators

I am a newbie when it comes to Excel, please help...

Postby chinch sacs » Fri Jan 30, 2004 6:15 pm

I just need to find out how to divide 1 column by another.

I'm sure there is a very simple formula, I just dont use Excel and I am trying to learn by playing with it (not going very well by the way)

I'm sure the formula looks something like:

(D2:D473) / (C2:C473)

but that doesnt work...

Thanks in advance ;-D
Fantasy sports are ruled by the 50-50-90 rule...

Anytime you have a 50/50 choice between two players, 90% of the time, you'll get it wrong
chinch sacs
General Manager
General Manager

User avatar
Mock(ing) Drafter
Posts: 2938
Joined: 17 Feb 2003
Home Cafe: Baseball
Location: San Jose, CA

Postby LBJackal » Fri Jan 30, 2004 6:22 pm

Do you want to divide the totals, or each individual row?

If you want to divide totals, then your formula will work. make sure it has an = sign in front of it though, so excel recognizes it as a function.

To do it individually, which is usually the case when dealing with stats, do it like this:

=(D2/E2) - make sure you press enter after you put in the formula or it'll go all weird.

Then, click on the cell you put that formula in, and don't let go of the mouse. Drag it all the way to the bottom of the list of players. Now the whole column should be highlighted. Click on Edit; Fill; Down. That should do the trick.
Image

"Jack, will you call me, if you're able?"

"I've got your phone number written, in the back of my Bible."
LBJackal
Hall of Fame Hero
Hall of Fame Hero

User avatar
Pick 3 Weekly Winner
Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

Postby LBJackal » Fri Jan 30, 2004 6:26 pm

BTW: good luck in manipulating RotoTimes' 2004 hitters projections ;-D

I was going through them and customizing them to fit my leagues scoring criteria yesterday. I knew the number 473 sounded familiar ;-D I feel like Matlock :-b
Image

"Jack, will you call me, if you're able?"

"I've got your phone number written, in the back of my Bible."
LBJackal
Hall of Fame Hero
Hall of Fame Hero

User avatar
Pick 3 Weekly Winner
Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

Postby chinch sacs » Fri Jan 30, 2004 6:29 pm

LBJackal wrote:BTW: good luck in manipulating RotoTimes' 2004 hitters projections ;-D

I was going through them and customizing them to fit my leagues scoring criteria yesterday. I knew the number 473 sounded familiar ;-D I feel like Matlock :-b


Crap I have been found out :-X

I will try what you said, thanks ;-D
Fantasy sports are ruled by the 50-50-90 rule...

Anytime you have a 50/50 choice between two players, 90% of the time, you'll get it wrong
chinch sacs
General Manager
General Manager

User avatar
Mock(ing) Drafter
Posts: 2938
Joined: 17 Feb 2003
Home Cafe: Baseball
Location: San Jose, CA

Postby chinch sacs » Fri Jan 30, 2004 6:34 pm

Hot Damn! It worked!

Thanks LB ;-D
Fantasy sports are ruled by the 50-50-90 rule...

Anytime you have a 50/50 choice between two players, 90% of the time, you'll get it wrong
chinch sacs
General Manager
General Manager

User avatar
Mock(ing) Drafter
Posts: 2938
Joined: 17 Feb 2003
Home Cafe: Baseball
Location: San Jose, CA

Postby Madison » Sat Jan 31, 2004 4:55 pm

LBJackal wrote:BTW: good luck in manipulating RotoTimes' 2004 hitters projections ;-D

I was going through them and customizing them to fit my leagues scoring criteria yesterday. I knew the number 473 sounded familiar ;-D I feel like Matlock :-b


Nice detective work. ;-D

Thanks for the information. ;-D
Yes doctor, I am sick.
Sick of those who are spineless.
Sick of those who feel self-entitled.
Sick of those who are hypocrites.
Yes doctor, an army is forming.
Yes doctor, there will be a war.
Yes doctor, there will be blood.....
Madison
Mod in Retirement
Mod in Retirement

User avatar
ExecutiveEditorCafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterInnovative MemberCafe MusketeerPick 3 ChampionMatchup Meltdown SurvivorLucky Ladders Weekly Winner
Posts: 53856
(Past Year: 1)
Joined: 29 Apr 2003
Home Cafe: Baseball
Location: Taking Souls...

Postby LBJackal » Sat Jan 31, 2004 5:01 pm

No problem........Matlock at your service :-b
Image

"Jack, will you call me, if you're able?"

"I've got your phone number written, in the back of my Bible."
LBJackal
Hall of Fame Hero
Hall of Fame Hero

User avatar
Pick 3 Weekly Winner
Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

Postby wrveres » Sat Jan 31, 2004 7:12 pm

chinch sacs wrote:
LBJackal wrote:BTW: good luck in manipulating RotoTimes' 2004 hitters projections ;-D

I was going through them and customizing them to fit my leagues scoring criteria yesterday. I knew the number 473 sounded familiar ;-D I feel like Matlock :-b


Crap I have been found out :-X

I will try what you said, thanks ;-D



LMAO .....


GL Chinch ;-D
wrveres
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterEagle EyeInnovative MemberCafe Musketeer
Posts: 31783
(Past Year: 702)
Joined: 2 Mar 2003
Home Cafe: Baseball


Return to Baseball Leftovers

Who is online

Users browsing this forum: Exabot [Bot] and 10 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

San Francisco at St. Louis
(7:37 pm)

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