Find max and minimum values in a section of a column, then do the same in next section.

**Tscott98** · 03-23-2020, 06:50 PM

I currently have a long list of time stamps in one column that looks like this:[ATTACH]668722

The column is divided in sections of varying length divided by a space.

I am trying to write a program that finds the min and the max (the earliest and latest time) value in each section and then copies those values to another column before moving on to the next section.

Any ideas and help would be appreciated.

A portion of the column is attached.

**José Augusto** · 03-23-2020, 07:40 PM

Hi

You can solve that without VBA.
Suppose your data in M2:M25
Use two columns P and Q (for example) as auxiliary columns. P records the start row of each group and Q the row where it ends
In P2 use and drag down the following formula

Formula:

Please Login or Register  to view this content.

In Q2 use and drag down

Formula:

Please Login or Register  to view this content.

To get the maximum use

Formula:

Please Login or Register  to view this content.

To get the minimum use

Formula:

Please Login or Register  to view this content.

See the file for clarification.

**jindon** · 03-23-2020, 11:04 PM

VBA

Please Login or Register  to view this content.

**Tscott98** · 03-24-2020, 11:12 AM

That did it, thanks!

**Tscott98** · 03-24-2020, 11:13 AM

Originally Posted by jindon

VBA

Please Login or Register  to view this content.

That did it, thanks!

**jindon** · 03-24-2020, 11:35 AM

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Find max and minimum values in a section of a column, then do the same in next section.

LinkBack

Thread Tools

Rate This Thread

Display

Find max and minimum values in a section of a column, then do the same in next section.

Re: Find max and minimum values in a section of a column, then do the same in next section

Re: Find max and minimum values in a section of a column, then do the same in next section

Re: Find max and minimum values in a section of a column, then do the same in next section

Re: Find max and minimum values in a section of a column, then do the same in next section

Re: Find max and minimum values in a section of a column, then do the same in next section

Thread Information

Users Browsing this Thread

Similar Threads

* Copy sub section total value to main section*

[SOLVED] sort a section if cells in section contains certain values

Hide a section based on the click of a box in the beginning of the section

2 Panes, Different Scale - 1 Heading Section Above, 1 Pivot Table Section Below

Deleting Row Section without Disrupting Formula Range Outside of Deleted Section

Moving section headings from below section to above section..

move that Row From the Waiting section to the completed section automaticly

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions