Results 1 to 10 of 10

Thread: Numbered column in vba

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 07-01-2012, 11:54 PM #1
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    14
    Quote Originally Posted by Admin View Post
    Hi

    You could try this formula.

    =COUNTIF($A$1:$A$9,A1)-COUNTIF($A$1:A1,A1)+1
    Another formula that can be used is this one...

    =COUNTIF(A1:A$9,A1)

    Change both A1 references to the cell reference for the cell that your data actually starts at.
    Last edited by Rick Rothstein; 07-02-2012 at 12:19 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Macro To Create A New Column Of Unique Values From Another Column Of Duplicates
    By ketats1 in forum Excel Help
    Replies: 10
    Last Post: 05-23-2013, 12:30 PM
  2. VBA Code To Highlight Duplicate Values In A Column
    By shonu in forum Excel Help
    Replies: 6
    Last Post: 05-16-2013, 09:56 AM
  3. Numbered List Of Unique Values
    By xander1981 in forum Excel Help
    Replies: 6
    Last Post: 01-21-2013, 06:10 PM
  4. MS-Access Set Default Value of Column Using VBA
    By LalitPandey87 in forum Access Help
    Replies: 2
    Last Post: 04-08-2012, 09:40 AM
  5. Splittting Data Into Different Worksheets Column Wise In VBA
    By rajeshd@live.in in forum Excel Help
    Replies: 1
    Last Post: 01-21-2012, 04:45 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
  •  

Forum Rules