Loop Macro to Find Minimum Date for Column Data

**abpexcelforum** · 09-05-2011, 04:18 PM

Hello,
I'm struggling to find a way to automatically display the minimum date for each segment of data in column C shown in the attached file. Column D shows the filter I'm trying to achieve for all data in column C. I was thinking I need a macro that finds the minimum date in the column C cells that is between the non-date cells and displays the value in column D under the segment indicated by the darker shade. I greatly appreciate your help. I have no experience with VBA but am willing to try if you have any hints.
Thanks,
Adam

**MarvinP** · 09-05-2011, 05:03 PM

Hi Adam and welcome to the forum,

I created a formula in Column B to put the red number next to each date. Then I copy and pasted over the column B with values only. Then sort by red color in column C and delete those rows. This then allowed me to create a pivot table and display Min values associated with each number. See attached. I think this is what you wanted.

Loop Macro to Find Minimum Date for Column Data

LinkBack

Thread Tools

Rate This Thread

Display

Loop Macro to Find Minimum Date for Column Data

Re: Loop Macro to Find Minimum Date for Column Data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions