turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Finding minimum value within each repeating sequence of column values

Topic Options

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

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

Sep 20, 2009 6:15 PM
(1056 views)

What formula will find a minimum value within each repeating sequence of column values?

I have a large database in which I wish to report the minimum (maximum) value within each 7-member, repeating sequence in a column of real values.

Thanks for any help.

I have a large database in which I wish to report the minimum (maximum) value within each 7-member, repeating sequence in a column of real values.

Thanks for any help.

2 REPLIES

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

You can go to Tables>Summary>Column of Interest>Statistics>Min

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

To add to above comment: If you have or can make an index column with an unique value for each of your series you can add that to the "Group" field in the Summary dialog in order to get the minimum for each of the series.