+ Reply to Thread
Results 1 to 4 of 4

Formula for incremental increase of count

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Formula for incremental increase of count

    I am trying to write a formula that only uses a single column to looks at the column to the left and creates the string plus the number of occurrences. The attached spread sheet makes it easier to understand. Thanks for any help.
    Attached Files Attached Files
    Last edited by BRISBANEBOB; 09-15-2016 at 12:02 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula for incremental increase of count

    e
    f
    g
    5
    a a1 f5: =e5 & countif(e$5:e5, e5)
    6
    b b1
    7
    c c1
    8
    d d1
    9
    a a2
    10
    b b2
    11
    d d2
    12
    a a3
    13
    d d3
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Formula for incremental increase of count

    Thank you - can't believe everything I tried fell in a heap.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula for incremental increase of count

    You're welcome.

+ 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: 2
    Last Post: 05-19-2016, 03:49 PM
  2. [SOLVED] incremental increase in a cell based on value increase in another cell
    By umuni in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-18-2014, 05:23 AM
  3. Incremental increase by week when the total for month is known
    By Redsohare in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-09-2014, 09:38 PM
  4. Need to calculate incremental increase
    By denk15 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-25-2013, 08:03 AM
  5. [SOLVED] Incremental Date Increase in Body of Text Using Word
    By golfervaughan in forum Word Formatting & General
    Replies: 6
    Last Post: 07-17-2012, 10:27 AM
  6. Incremental increase if previous cell is shaded
    By Nicely in forum Excel General
    Replies: 0
    Last Post: 03-01-2012, 10:36 PM
  7. Formula for incremental increase
    By alexrm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2005, 06:05 PM

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