+ Reply to Thread
Results 1 to 3 of 3

Referencing back to cells for formula

  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    29

    Lightbulb Referencing back to cells for formula

    Removing File.
    Last edited by ohanish; 03-27-2015 at 04:42 PM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Referencing back to cells for formula

    I see that you are using full column references. This might be convenient but it is something that can eat up the computing resources.
    I would change some of the references in your formula to mixed relative and absolute so that you can copy down and across. This formula has also limited the ranges instead of having whole column ranges.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The formula in your table comes down to this (not using the intermediate formula).
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I'm not familiar enough with your workbook to see how you would use this and unfortunately, I don't have the time to figure out how you can make use of this table.
    Last edited by newdoverman; 03-26-2015 at 04:36 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    02-14-2014
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Referencing back to cells for formula

    Thanks. I see that I over thought this entire thing now.

+ 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. Replies: 9
    Last Post: 11-19-2014, 04:15 PM
  2. Replies: 4
    Last Post: 02-18-2014, 08:37 PM
  3. Excel formula to bring back cells two cells down?
    By dianedeetran in forum Excel General
    Replies: 2
    Last Post: 06-26-2012, 03:38 PM
  4. Referencing from multiple sheets back to sheet1
    By troth in forum Excel General
    Replies: 6
    Last Post: 02-25-2011, 12:02 PM
  5. Replies: 1
    Last Post: 08-01-2006, 03:18 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