Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Sequential numbering in Excel (https://www.askmehelpdesk.com/showthread.php?t=7622)

  • Feb 5, 2005, 09:32 AM
    marzocchi
    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
  • Feb 15, 2005, 04:53 PM
    walt17
    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.
  • Oct 22, 2012, 12:51 PM
    Darkthorne
    Formula in the second column is
    =COUNTIF($A$1:A1,A1)
  • Oct 27, 2012, 11:02 PM
    JBeaucaire
    Slight correction to Darkthorne's formula, in case the formula gets copied to the right:

    =COUNTIF($A$1:$A1, $A1)

  • All times are GMT -7. The time now is 06:51 AM.