Calculating Min Value from a Series of Unique Values......

[Still_Learning_Excel]

I have a series of data (c. 200k rows) with a sample below, and I'm after a formula that will give me the Min value for Start Date for each unique Item ID. I have used a formula (=days(today(),[Start-Date]) to calculate the days, but how do I identify only the min value for each of the SKUs listed?

All help appreciated.


ItemID SellingCode Price Start-Date
0800000130 5000371016353 3.49 29/11/2016 00:00
0800000130 50371310 3.49 29/11/2016 00:00
0800000176 5000371051194 4.49 29/11/2016 00:00
0800000176 5010273000923 4.49 29/11/2016 00:00
0800000383 5060002360279 4.99 01/01/1900 00:00
0800000384 5060002361184 4.99 01/01/1900 00:00
0800000384 5060002360286 4.99 01/01/1900 00:00
0800000573 5060002360347 4.99 01/01/1900 00:00
0800000574 5060002361412 1.99 01/01/1900 00:00
0800000574 8006320031078 1.99 01/01/1900 00:00
0800000574 5060002360941 1.99 01/01/1900 00:00
0800000663 5000371051200 2.00 01/01/1900 00:00
0800001521 2100001551988 0.99 01/01/1900 00:00
0800001521 8006933055690 0.99 01/01/1900 00:00
0800001521 5060002361078 0.99 01/01/1900 00:00
0800001521 8006320049332 0.99 01/01/1900 00:00
0800001559 2100001553609 0.30 01/01/1900 00:00
0800001559 5060002361511 0.30 01/01/1900 00:00
0800001559 5060002361177 0.30 01/01/1900 00:00
0800001559 5060002361207 0.30 01/01/1900 00:00
0800001560 8006320028498 1.29 01/01/1900 00:00
0800001560 2100001553616 1.29 01/01/1900 00:00
0800001560 8006933055003 1.29 01/01/1900 00:00
0800001560 5060002361528 1.29 01/01/1900 00:00
0800001560 5060002361214 1.29 01/01/1900 00:00

 

[DRSteele]

The quickest and simplest solution is a Pivot Table.

 

[Still_Learning_Excel]

Can you explain how. I have tried to pivot the data, but it still details all of the individual entries for all of the ItemIDs, whereas all I want to do is show the min value only....


[TABLE="width: 511"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Concat Ref[/TD]
[TD]ItemID[/TD]
[TD]SellingCode[/TD]
[TD]Price[/TD]
[TD]Min of Days[/TD]
[/TR]
[TR]
[TD]08500344062100003159076[/TD]
[TD]0850034406[/TD]
[TD]2100003159076[/TD]
[TD="align: right"]30.00[/TD]
[TD="align: right"]478[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]54.00[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]2100003159076 Total[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]113[/TD]
[/TR]
</tbody>[/TABLE]

 

[DRSteele]

Please provide better sample data and expected outcome.