Choosing Oldest Date From Multiple Occurences of Same Category

[gumbygr]

Thanks for taking the time to try and help solve this problem
I have been struggling with.

I have two sheets. The first sheet 214 S contains data.

The second sheet 214 Lst is where the output goes.

I was looking for a formula or macro that can do the following in excel 2013 for win7:
I was experimenting with Index and Match but I wasn't getting it right.

In sheet 214 S I would like it to look in Column A within each
category/field such as 99 - Tools for the item with the oldest date.

For example the formula or macro would look at all the entries for
99 - Tools (there are 2 entries in the example) and output the oldest date
out of the 99 - Tools entries (which is cell G2 7/1/2017) to another
sheet called 214 Lst in cell B2.

For 100 - Non Tools it would find the oldest date (which is cell G4 8/6/2017) and output
to cell B3 on sheet 214 Lst, and repeat so on down the list until the end of Column A.

(sheet 214 S)

Label1	Label2	Label3	Label4	Label5	Label6	Date
99 - Tools	12	x	x	x	x	7/1/2017
99 - Tools	19	x	x	x	x	8/6/2017
100 - Non Tools	103	x	x	x	x	8/6/2017
100 - Non Tools	108	x	x	x	x	8/22/2017
105 - Main	203	x	x	x	x	8/22/2017
105 - Main	751	x	x	x	x	7/7/2017
105 - Main	663	x	x	x	x	6/28/2017
110 - Misc	29	x	x	x	x	8/5/2017
110 - Misc	35	x	x	x	x	8/6/2017
110 - Misc	98	x	x	x	x	8/28/2017
130 - NT	7	x	x	x	x	8/6/2017
135 - Leisure	100	x	x	x	x	8/6/2017

<tbody>
</tbody>

(sheet 214 Lst)

Label1	Oldest Date
99 - Tools	7/1/2017
100 - Non Tools	8/6/2017
105 - Main	6/28/2017
110 - Misc	8/5/2017
130 - NT	8/6/2017
135 - Leisure	8/6/2017

<tbody>
</tbody>

Thanks again.

 

[oldbrewer]

why is not 100-non tools 8/22/17

 

[oldbrewer]

please ignore my last post

can you sort the table by label ascending and date ascending - then it is the date by first occurrence of label

 

[gumbygr]

You might be on to something.

I'll check on that suggestion to see if that works out right. My brain was fried trying to figure things out.

 

[Marcelo Branco]

Try a Pivot Table

M.

 

[gumbygr]

A pivot table and some extra sorting with added layers did the trick. I apologize for posting the question because I kept looking for a complex answer for a question that needed a much simpler answer. Thank you everyone for your help.