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

- Start Article
- 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

Finding minimum value within each repeating sequence of column values

Sep 20, 2009 6:15 PM
(1170 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 2

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

Re: Finding minimum value within each repeating sequence of column values

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

Re: Finding minimum value within each repeating sequence of column values

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.