Ask Experts Questions for FREE Help !
Ask
    marzocchi's Avatar
    marzocchi Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Feb 5, 2005, 09:32 AM
    Sequential numbering in Excel
    Hi,
    I'm trying to number a column in sequential order by counting the number of times a certain word is typed in another range.
    For example:
    AAA 1
    BBB 1
    AAA 2
    AAA 3
    CCC 1

    I need the numbers to be in sequence in column B:B every time a word is typed multiple times in column A:A.

    Hope this makes sense.
    Thanks,
    Marzocchi
    walt17's Avatar
    walt17 Posts: 335, Reputation: 28
    Full Member
    		  
    #2

    Feb 15, 2005, 04:53 PM
    I think I understand what you want to do. But... it is going to be extremely difficult and complex to do so in Excel. You really need to switch to a database program for something like that.
    Darkthorne's Avatar
    Darkthorne Posts: 4, Reputation: 1
    New Member
    		  
    #3

    Oct 22, 2012, 12:51 PM
    Formula in the second column is
    =COUNTIF($A$1:A1,A1)
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Oct 27, 2012, 11:02 PM
    Slight correction to Darkthorne's formula, in case the formula gets copied to the right:

    =COUNTIF($A$1:$A1, $A1)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel Format [ 7 Answers ]

I need someone help. Everyday I need to format data like the following 1003, 1876, 1952, 2011, 2048, 2057, 2073, 2094, 2111, 2128 This gets pasted into one cell in a spreadsheet. I would like to be able to format it so it goes into the sheet 1003 1876 1952 etc into separate cells. Is this...

Windows excel [ 1 Answers ]

Can anyone advise how to create a form with excel that is for continuous checks, form size: 8.5" x 7"? Page Setup Does Not Do The Job. The printer I'm using is an EPSON FX-880.

Excel [ 2 Answers ]

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

Serial Numbering of Records [ 4 Answers ]

I have a query based on a table with the fields such as firstname and lastname. I am running a report which list down all the records. But I want to print a row number / serial number as first column in the report. Sample SL. No. FirstName LastName 1. Sam ...

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...

View more questions Search