+ Reply to Thread
Results 1 to 3 of 3

percentage change from previous cell over a column.

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    Sacramento Ca
    MS-Off Ver
    Office 365
    Posts
    4

    percentage change from previous cell over a column.

    I need some direction. I've tried looking through the forum, but I feel like I'm probably asking the wrong question. I'm relatively comfortable with excel but just moved out of 2007 and into 365. And it's been a couple years since I've had to lean on a formula this heavily.

    I have monthly data from 1919 to 2014 for the US Industrial Production Index. That's 1147 data points. I need to find a way to apply a formula for yearly percentage change over the entire column.

    So I need cell b2 to =a2/a1, then a value for b3 to =a3/a2 and so on.

    First and foremost, does anyone know how to do that? Or can you point me in the right direction?
    Secondly is there a term for what I'm trying to do that would make my search a bit more fruitful?

    I appreciate any help, thanks.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,581

    Re: percentage change from previous cell over a column.

    Hi
    yoiu seem to be on the right track. Enter =A2/A1 in B2 and pull down as needed ( or right click the handle at the rightg lower corner of the cell to expand automatically

  3. #3
    Registered User
    Join Date
    10-09-2014
    Location
    Sacramento Ca
    MS-Off Ver
    Office 365
    Posts
    4

    Re: percentage change from previous cell over a column.

    Have you ever seen a grown man facepalm in public? Thank you. You just cleared a major hurdle for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change background color of cell if previous column cell value is different.
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2014, 08:25 AM
  2. Need to hide pivot column if it is first change from previous
    By RockyP in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-25-2013, 03:40 PM
  3. Replies: 6
    Last Post: 05-14-2009, 01:41 AM
  4. Can I change column width for remainder but NOT previous text?
    By Amymariebower in forum Excel General
    Replies: 1
    Last Post: 05-23-2006, 06:10 PM
  5. Want to change current prices in a column by a percentage
    By Sharon43 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2006, 03:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1