Flagging / Extracting Data

[MamaBear]

Hi all; I'm VERY happy to have found the videos and this website!

Thank you in advance to anyone for guidance on this:

1 large spreadsheet. Column E has duplicate data, Column F has unique data and there is a date field.

I need to group column E and Column F - column E is the grouper criteria
AND I need to flag the first unique event in Column F.

For example:

Column E - Column F - Date field
Data A - 4654654 - Jan 1, 2011 [ this flagged ]
Data A - 4687104 - March 1, 2011
Data B - 4654657 - Feb 1, 2011
Data C - 4454445 - June 1, 2011 [ this flagged ]
Data C - 6465405 - June 15, 2011
Data C - 4640544 - August 1, 2011

The ultimate goal is to extra Column E where there are duplicates and then analyze the first event to see what caused the second event, etc.

HELP!

Thanks!

 

[MamaBear]

Thanks all for looking, I finally figured it out.

I found a pattern and created a macro to run from that pattern.

I hope the rest of this project gets finished like this!