Results 1 to 5 of 5

Incrementing a cell contents by 1 based on a condition and previous value

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2007
    Location
    Oregon
    Posts
    79

    Incrementing a cell contents by 1 based on a condition and previous value

    The sheet "Award Code" contains the code which are constant numbers.

    The sheet "Jan" contains some data

    The sheet "Feb" is the main sheet where we want to get some work done.

    Basically if the ELIGIBLE column (B) is YES, then we increment the value of the corresponding AWARD column (C) by 1 then what was for it in the previous ("Jan") Sheet.

    So for example, in the "Jan" sheet the cell C4 had a value of "2". So in "Feb" sheet, since B4 is "Yes", C4 has gets a value of "3" (2 + 1).

    One boundary condition is that if the value of AWARD col reaches "19" then it gets reset to "1" again.

    Attach is the excel sheet.

    Thanks
    Attached Files Attached Files

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