Really stupid excel question - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Really stupid excel question

Moderator: Baseball Moderators

Really stupid excel question

Postby nikku88 » Tue Mar 08, 2005 8:54 am

Ok, I haven't used excel for a long time, so it's all very fuzzy.
let's say I have different numbers in column A and I want to subtract the same number from all of them.
What is the easiest way to do this?
I could probably figure it out, but my Japanese hasn't gotten quite good enough to understand what even half of the functions will do.

Thanks.
Image
My apologies. I have a nephew named Anfernee, and I know how mad he gets when I call him Anthony. Almost as mad as I get when I think about the fact that my sister named him Anfernee.
nikku88
Major League Manager
Major League Manager

User avatar

Posts: 1438
Joined: 10 Oct 2004
Home Cafe: Baseball
Location: Osaka

Postby Mercer Boy » Tue Mar 08, 2005 8:58 am

You could make a static field (meaning some random field somewhere) with the number you want to subtract...then do an easy function A(X = whatever field your column of numbers are) - B(Y = wherever your number is located) and then just copy down the function.

Or, I'm sure there is a way in the function menu to just input the same formula without having the number you want to subtract in a field...then copy it down the whole way. :-)
Image
The One, The Only, The Incomparable Mercer Boy.
MySpace blog (updated 6/21 - Pirates walkout.)
Mercer Boy
General Manager
General Manager

User avatar
Eagle EyePick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3455
Joined: 22 Oct 2003
Home Cafe: Football
Location: New Castle, PA

Postby LBJackal » Tue Mar 08, 2005 9:22 am

In the top cell of the new column where the new numbers should show up (I'll assume this is B1 with the column of old numbers starting in A1) type "=(A1-X)" where X is the number you're subtracting, and without the quotes around it. Then, highlight the entire column, starting with B1 and moving down, and then go to Edit; Fill Down. You can also click and drag down the bottom right corner of cell B1 and that does the same thing.

If you have any more excel questions, let me know, I've been using it a ton recently. A cool thing I noticed is that if you want the top row to stay visible even if you're scrolling down hundreds of cells (such as, say, looking at a bunch of baseball stats :-D ) then all you have to do is click on Row 2 so the entire row is highlighted, and go to Window; Freeze Panes. It's so simple, but I never noticed it until a few days ago.
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 StlSluggers » Tue Mar 08, 2005 10:15 am

I would recommend a simple formula in cell B1... =A1-X.

Copy and paste. Pretty simple.

I'm not an expert, but as an accountant, I have to use Excel for every freaking thing I do. You're more than welcome to ask me questions, too.
StlSluggers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterMock(ing) DrafterWeb Supporter
Posts: 14716
Joined: 24 May 2004
Home Cafe: Baseball
Location: Parking in the gov't bldg @ 7th and Pine. It's only $3.00 on game day!

Postby nikku88 » Tue Mar 08, 2005 11:47 am

Thanks for all the help guys. I managed to do it. Stupid Chinese characters!
Image
My apologies. I have a nephew named Anfernee, and I know how mad he gets when I call him Anthony. Almost as mad as I get when I think about the fact that my sister named him Anfernee.
nikku88
Major League Manager
Major League Manager

User avatar

Posts: 1438
Joined: 10 Oct 2004
Home Cafe: Baseball
Location: Osaka


Return to General Talk

Who is online

Users browsing this forum: unioreimi and 3 guests

cron
Forums Articles & Tips Sleepers Rankings Leagues


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

San Francisco at Kansas City
(8:07 pm)

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