Ask Experts Questions for FREE Help !
Ask

Sequential numbering in Excel

Asked Feb 5, 2005, 08:32 AM — 3 Answers
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

Search this Thread
Share |
3 Answers
walt17's Avatar
walt17 Posts: 315, Reputation: 125
Full Member
  
#2

Feb 15, 2005, 03: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.
Helpful
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)
Helpful
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5041
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)
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



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 certian cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 peices of data that I want to enter and then place those in the proper cells and then...

View more Spreadsheets questions Search