Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Create sequential

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 8, 2019 2:47 AM
(4254 views)

I have data as below (column A, B, and C), I would like to create sequence column by add formula.

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

If you are trying to create the sequence column, here is the formula that recreates the column you showed. It is based upon the formula @txnelson provided.

Attached is the table and the Sequence column with a formula.

4 REPLIES 4

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Create sequential

Here is one form of a formula that will work

```
if(row()==1, x=0);
If(:c==0, x=x+1);
x;
```

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Create sequential

The Sequence() function is what you're looking for.

-Jeff

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

If you are trying to create the sequence column, here is the formula that recreates the column you showed. It is based upon the formula @txnelson provided.

Attached is the table and the Sequence column with a formula.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Create sequential

Thanks all for solve my problem. I try all solution that you provide and gzmorgan0's formula is the best match my problem.

@gzmorgan0 wrote:If you are trying to create the sequence column, here is the formula that recreates the column you showed. It is based upon the formula @txnelson provided.

Attached is the table and the Sequence column with a formula.

Article Labels

There are no labels assigned to this post.