+ Reply to Thread
Results 1 to 8 of 8

Adding Sequential Numbers in Column B Based on Column A Values

Hybrid View

habsfan1433 Adding Sequential Numbers in... 02-14-2014, 03:42 PM
XOR LX Re: Adding Sequential Numbers... 02-14-2014, 03:44 PM
habsfan1433 Re: Adding Sequential Numbers... 02-14-2014, 03:50 PM
JOHN H. DAVIS Re: Adding Sequential Numbers... 02-14-2014, 04:07 PM
JOHN H. DAVIS Re: Adding Sequential Numbers... 02-14-2014, 03:50 PM
XOR LX Re: Adding Sequential Numbers... 02-14-2014, 03:53 PM
XOR LX Re: Adding Sequential Numbers... 02-14-2014, 04:12 PM
JOHN H. DAVIS Re: Adding Sequential Numbers... 02-14-2014, 04:17 PM
  1. #1
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Adding Sequential Numbers in Column B Based on Column A Values

    Hi,

    Not sure about adapting this to your table structured references, but based on a list starting in A1:

    =COUNTIF(A$1:A1,A1)

    and copy down.

    Cheers
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  2. #2
    Registered User
    Join Date
    03-17-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Adding Sequential Numbers in Column B Based on Column A Values

    Wow...thanks XOR LX! That was easy

    EDIT: Sorry John, you got beat to the punch!

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Adding Sequential Numbers in Column B Based on Column A Values

    Quote Originally Posted by habsfan1433 View Post
    Wow...thanks XOR LX! That was easy

    EDIT: Sorry John, you got beat to the punch!
    Oh well, that's the breaks!!

+ 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. [SOLVED] Adding a value to a column based on values in another column fro the same worksheet
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2013, 06:31 PM
  2. Replies: 1
    Last Post: 11-05-2013, 11:22 AM
  3. Replies: 3
    Last Post: 01-10-2012, 10:41 PM
  4. Replies: 2
    Last Post: 12-20-2011, 02:26 PM
  5. adding values of a column based on another column content
    By gideong in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2009, 11:53 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