+ Reply to Thread
Results 1 to 2 of 2

Reference Cell in Prior Row (Formatted Table)

  1. #1
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    163

    Reference Cell in Prior Row (Formatted Table)

    Hi --

    I'm trying to write a formula in a formatted table that can take a value in an adjacent column, current row, let's say [@Total Sales], and subtracts the value of the previous row in the 'Total Sales' column.
    In this example, the result would give you the difference in Total Sales for that period vs the prior. I know I can do this by simply referencing the cell in the prior row, but I'd prefer to only have named references if possible.

    For instance (but I know this isn't the case): [@Total Sale],Offset[-1]

    Does this make sense?
    Can it be done?

    Thank you!

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Reference Cell in Prior Row (Formatted Table)

    Post deleted.
    Last edited by kvsrinivasamurthy; 12-07-2020 at 10:47 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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] VBA to Insert Formatted Rows Based On Cell Reference
    By hindotmo12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2020, 06:03 PM
  2. Replies: 10
    Last Post: 08-17-2020, 02:33 AM
  3. Indirect with Formatted Tables (single cell reference)
    By xtinct2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2018, 01:13 PM
  4. [SOLVED] How to reference a conditionally formatted cell(s)
    By EXCELNEWCOMER in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-22-2013, 04:34 AM
  5. [SOLVED] How to reference a Conditional Formatted Cell ?
    By EXCELNEWCOMER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2013, 04:54 AM
  6. How to keep formatted table column reference static when autofilling
    By chrisjames25 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2012, 10:23 AM
  7. Replies: 1
    Last Post: 02-07-2005, 02:06 PM

Tags for this Thread

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