# sequemce Formula

1. ## sequemce Formula

I have a massive list of Data this needs to have sequence be numbers in sequence in the colum beside the data is raandom in cells, PLease see the example underneath it will be easier to explain

Data237828
Data237828
Data237828
Data237828
Data237828
Data237828
Data237828
Data237828
Data876378
Data876378
Data876378
Data876378
Data876378
Data876378
Data876378
Data7868
Data7868
Data7868
Data893798389
Data893798389
Data893798389
Data893798389
Data893798389
Data893798389
Data234352
Data234352
Data234352
Data234352

Anyone know how to write a sequence formula so the final product in the column beside will have a sequence numbering please see below

Data237828 1
Data237828 2
Data237828 3
Data237828 4
Data237828 5
Data237828 6
Data237828 7
Data237828 8
Data876378 1
Data876378 2
Data876378 3
Data876378 4
Data876378 5
Data876378 6
Data876378 7
Data7868 1
Data7868 2
Data7868 3
Data893798389 1
Data893798389 2
Data893798389 3
Data893798389 4
Data893798389 5
Data893798389 6
Data234352 1
Data234352 2
Data234352 3
Data234352 4

2. ## Re: sequemce Formula

This may be of some help. It uses helper columns where the first cell of the first column is 1 and the following cells have the formula:
``Please Login or Register  to view this content.``
The second helper column concatenates the other columns with the formula:
``Please Login or Register  to view this content.``
Here is a file showing how this would work for your example:

Sequence Formula.xlsx

Let me know if you have any questions.

3. ## Re: sequemce Formula

You could just put

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

4. ## Re: sequemce Formula

That worked thanks so much!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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