1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

[Resolved] Calculate a column of numbers

Discussion in 'Business Applications' started by blueboy75, Sep 24, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. blueboy75

    blueboy75 Thread Starter

    Joined:
    Nov 22, 2002
    Messages:
    78
    I have an excel spreadsheet and in 1 column i have a few numbers, (i say a few in fact there are hundreds), now i need to increase all these numbers by 10%

    is there anyway i can do this without doing the numbers individually
     
  2. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    I would do it by using a formula in another column.

    say you have 10 in cell a1, well in b1 I would have =a1*1.1

    then I would copy that formula to all the rows in that colum corresponding to the amount of rows you have in your original column. that will give you the increase of 10%.

    Next couple the entire colum and the Paste Special, Values in the original colum.

    done.
     
  3. CastleHeart

    CastleHeart

    Joined:
    May 4, 2002
    Messages:
    743
    Go to the column next to it - say D
    in D1 enter = C1*1.10 and exit the cell

    Go to the bottom corner of that cell till you get the + sign
    Click and drag down to copy the formulas

    If you want these numbers in the original cells simply click the "D" column heading and copy the column - Then click the "C" column heading and PASTE SPECIAL\ VALUES .

    (If the hole column isn't involved then just copy and paste a selection. If there is no vacant column next to C to work with, go to a blank column or insert one next to C and then remove it when you're done)


    - C
     
  4. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    >> is there anyway i can do this without
    >> doing the numbers individually

    For sure. Put 1.1 in a free cell (another sheet if necessary) and copy it.

    Select the range to be increased, then Edit -- Paste Special -- Multiply -- OK.

    Rgds,
    Andy
     
  5. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    cool,, much handier!!;):D(y)
     
  6. CastleHeart

    CastleHeart

    Joined:
    May 4, 2002
    Messages:
    743
    Most efficient XLG (y)
     
  7. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Cheers guys. Hey CH, glad to see you're acquainted with the Fill Handle. Didya know you can doubleclick it to fill down as far as there's data in the neighbouring column?

    ;) ,
    Andy
     
  8. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    I didn't know it!! Cool!(y)
     
  9. CastleHeart

    CastleHeart

    Joined:
    May 4, 2002
    Messages:
    743
    I think I did!
    But it seems that I have the Clear History setting in my brain set to a shorter time period right now and that knowledge may have been deleted!

    :D

    Actually ... I have double clicked the handle of a cell to copy a formula down THAT column as far as there is data. But never done the 'neighboring cell' thing.

    - C
     
  10. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    "I didn't know it!! Cool!"

    Randy!!?? I thought I taught you better!! :)
     
  11. CastleHeart

    CastleHeart

    Joined:
    May 4, 2002
    Messages:
    743
    Say...I'm not getting any thread notification Emails. Is it down or did I do something I shunta ?

    - C :confused:
     
  12. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Prolly dun sumpin ewe shunta.
     
  13. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    doubl-clicking the little plus dealie bob?? Jeez!! Now I hafta know everthing, huh??;):D


    :p
     
  14. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Get it straight. It's not "the little plus dealie bob", it's "the blob in the bottom, right corner of the cell"

    Oh...and when you copy a cell, the thing that goes around it is called a marquee, and NOT marching ants!
     
  15. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    >> the thing that goes around it is called a marquee,
    >> and NOT marching ants!

    Excuse me DB? Word 2K? Format -- Font -- Text Effects -- Animations?

    ;) ,
    Andy
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - [Resolved] Calculate column
  1. FernJones
    Replies:
    2
    Views:
    188
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/167050

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice