Results 1 to 2 of 2

Thread: Excel Spreadsheet Problem

  1. #1
    Jun 2011

    Excel Spreadsheet Problem

    In an excel spreadsheet, I have a row of cells (we'll call it row #27) that show the results of the different inputs of it's column. Because of the way the spreadsheet was designed (not by me) these are every other column and there are 16 of them. The last column (the 17th) has the totals of the rows going across. In this last column, cell 27 needs to equal the value of the nearest cell to it's left that's not Null. In otherwords, at any given time, not every column is filled with info, and not until the column is filled out does the cell #27 produce a running calculation.
    Example: A27, C27, E27, G27 have values. I27, K27, and M27 does not ahve values. So N27 needs to show the same value as G27, but when the next update comes and I27 gets a value, N27 needs to show that. I hope this makes sense. I was told that Excel has this formula biult in, but I can't find it.

    Last edited by topsquark; Jun 16th 2011 at 04:59 AM.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    A Plied Mathematician
    Jun 2010
    CT, USA

    Re: Excel Spreadsheet Problem

    Are the values in, say, G27 and I27 guaranteed to be non-negative? If so, you could just let N27 be the max of G27 and I27.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Excel problem
    Posted in the Business Math Forum
    Replies: 3
    Last Post: Nov 22nd 2010, 10:56 AM
  2. Excel problem
    Posted in the Math Software Forum
    Replies: 0
    Last Post: Aug 5th 2010, 09:33 AM
  3. Help w/ Excel spreadsheet & probability
    Posted in the Statistics Forum
    Replies: 1
    Last Post: May 19th 2010, 09:51 PM
  4. Need Blackjack Spreadsheet
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: Jan 27th 2010, 03:49 PM
  5. Spreadsheet help
    Posted in the Pre-Calculus Forum
    Replies: 0
    Last Post: Oct 28th 2008, 04:37 PM

Search Tags

/mathhelpforum @mathhelpforum