Show Different Prices of Same Part

[south0085]

Thank you for your time.

I have a table that shows a Date, a Part Number, and a Price.

It's a cumulative table. So there are part numbers that have multiple different prices.

Column D shows the date.
Column I shows the part number.
Column J shows the price.

I would like to create a pivot table (or whatever...doesn't have to be a pivot table) that pulls out each part number and to the right of it, show the different prices and their corresponding dates.

Here's what my data looks like:

Sheet1

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	268450	7221	TMMC	10/6/2017	10/6/2017	268450	ABAC7284D14	E551	87910-0R210-C0	83.1808	83.3021	4	4	USD	IB	83168
2	268450	7221	TMMC	10/6/2017	10/6/2017	268450	ABAC7284D14	F260	87910-0R210-B0	38.9443	38.8914	4	4	USD	IB	83168
3	268450	7221	TMMC	10/6/2017	10/6/2017	268450	ABAC7284D14	E636	87940-0R190-B2	37.7509	38.2813	4	4	USD	IB	83168
4	268450	7221	TMMC	10/6/2017	10/6/2017	268450	ABAC7284D14	G537	87940-0R220-A1	37.7509	38.2813	4	4	USD	IB	83168
5	268450	7221	TMMC	10/6/2017	10/6/2017	268450	ABAC7284D14	G657	87940-0R190-K0	37.7509	38.2813	4	4	USD	IB	83168
6
7	268451	7221	TMMC	10/7/2017	10/6/2017	268451	ABAC7284D15	E480	87910-0R210-C0	38.9443	38.8914	8	8	USD	IB	83168
8	268451	7221	TMMC	10/7/2017	10/6/2017	268451	ABAC7284D15	G464	87940-0R190-A0	43.1304	43.6608	4	4	USD	IB	83168
9	268451	7221	TMMC	10/7/2017	10/6/2017	268451	ABAC7284D15	E402	87940-0R190-B1	43.1304	43.6608	4	4	USD	IB	83168
10	268451	7221	TMMC	10/7/2017	10/6/2017	268451	ABAC7284D15	E134	87940-0R190-B2	43.1304	43.6608	8	8	USD	IB	83168
11	268451	7221	TMMC	10/7/2017	10/6/2017	268451	ABAC7284D15	G337	87940-0R190-C0	43.1304	43.6608	12	12	USD	IB	83168
12	268451	7221	TMMC	10/7/2017	10/6/2017	268451	ABAC7284D15	G497	87940-0R190-D1	43.1304	43.6608	4	4	USD	IB	83168
13	268451	7221	TMMC	10/7/2017	10/6/2017	268451	ABAC7284D15	G883	87940-0R190-K0	43.1304	43.6608	4	4	USD	IB	83168
14
15	268450	7221	TMMC	10/9/2017	10/6/2017	268450	ABAC7284D14	E551	87910-0R210-C0	14.2154	83.3021	4	4	USD	IB	83168
16	268450	7221	TMMC	10/9/2017	10/6/2017	268450	ABAC7284D14	F260	87910-0R210-B0	65.1232	38.8914	4	4	USD	IB	83168
17	268450	7221	TMMC	10/9/2017	10/6/2017	268450	ABAC7284D14	E636	87940-0R190-B2	14.6445	38.2813	4	4	USD	IB	83168
18	268450	7221	TMMC	10/9/2017	10/6/2017	268450	ABAC7284D14	G537	87940-0R220-A1	78.1258	38.2813	4	4	USD	IB	83168
19	268450	7221	TMMC	10/9/2017	10/6/2017	268450	ABAC7284D14	G657	87940-0R190-K0	46.4878	38.2813	4	4	USD	IB	83168

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 49px;"><col style="width: 35px;"><col style="width: 46px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 49px;"><col style="width: 93px;"><col style="width: 37px;"><col style="width: 105px;"><col style="width: 68px;"><col style="width: 56px;"><col style="width: 56px;"><col style="width: 21px;"><col style="width: 32px;"><col style="width: 19px;"><col style="width: 42px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4



And here's what I'd like my summary table to look like:

Sheet1

	I	J	K
22	87910-0R210-C0	10/6/2017	83.1808
23	87910-0R210-C0	10/7/2017	38.9443
24	87910-0R210-C0	10/9/2017	14.2154
25	87910-0R210-B0	10/6/2017	38.9443
26	87910-0R210-B0	10/9/2017	65.1232

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 105px;"><col style="width: 68px;"><col style="width: 56px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[south0085]

I'm an idiot. I can do this by sorting, can't I? haha Wow what am I thinking ??

 

[south0085]

But for some reason, I really do need help.

My list is 7,000 rows long. What I'm trying to do is send our Sales guy the most recent price for each part.

I guess that's my question. How can I do that?

If I merely sort, I have to still go in an pull the "most recent" part and price out manually.

Is there a workaround?

 

[MARZIOTULLIO]

	i​	j​	k​	l​	m​	n​	o​
20​	22​	87910-0r210-c0	10/6/2017​	83.1808​		87910-0r210-c0	14.2154​
21​	23​	87910-0r210-c0	10/7/2017​	38.9443​		87910-0r210-b0	65.1232​
22​	24​	87910-0r210-c0	10/9/2017​	14.2154​
23​	25​	87910-0r210-b0	10/6/2017​	38.9443​
24​	26​	87910-0r210-b0	10/9/2017​	65.1232​

<tbody>
</tbody>

O20=IFERROR(INDEX($L$20:$L$24,SMALL(IF($J$20:$J$24=N20,IF($K$20:$K$24=MAX($K$20:$K$24),ROW($L$20:$L$24)-ROW($L$20)+1)),COUNTIF($K$20:K20,K20))),"")

control+shift+enter copy down

 

[south0085]

Thank you!!