+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Circular Reference Issue

  1. #1
    Registered User
    Join Date
    06-23-2008
    Posts
    29

    Circular Reference Issue

    I have attached an example of what i am trying to do exactly. In cell A5 you will see the formula.

    I want to be able to refer to cell J5 and if there isn't an "x" than add 1 to the previous used cell in column B and than move the number that will be populate in A5 to B5. However i create this circular reference because it keeps searching for the last used cell in the column B. I will like to apply this formula to all cells in column A and referring to the corresponding cells in column J. Does anyone have any idea on how to overcome this problem
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Circular Reference Issue

    Not sure what do you required. Try this,

    B3, copy down.

    =IF(J3="x","",MAX(B$2:B2)+1)

    Does this help?
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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