+ Reply to Thread
Results 1 to 2 of 2

Increment adding of cells with text values and spaces in between

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    Taguig City, Philippines
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    95

    Increment adding of cells with text values and spaces in between

    Hi,

    I am trying to create increment numbers on my sheet and I was hoping to do it automatically. The thing is I cant just simply add 1 to the cell as there is a text value. Also, there are spaces in between, and the spaces varies from time to time.

    So I was hoping for a formula where it can just detect the last row value and add one to that without leaving the text part.

    In essence it goes like this, in cell A8

    A3 JE 1 (starting point)
    A4
    A5
    A6
    A7 JE 2 (add one from previous known value)
    A8
    A9
    A10 JE 3 (add one from previous known value)


    I have attached the sheet as well. In my sheet the formula =Row does not work as there are spaces in between so it is not counting correctly. I hope someone could help me out. Thank you!
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,154

    Re: Increment adding of cells with text values and spaces in between

    Try in A3 and fill down.

    =IF(D3<>"","JE "&COUNTIF($D$3:D3,"<>"),"")
    Dave

+ 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