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

TMMC

ABAC7284D14

E551

87910-0R210-C0

USD

IB

TMMC

ABAC7284D14

F260

87910-0R210-B0

USD

IB

TMMC

ABAC7284D14

E636

87940-0R190-B2

USD

IB

TMMC

ABAC7284D14

G537

87940-0R220-A1

USD

IB

TMMC

ABAC7284D14

G657

87940-0R190-K0

USD

IB

TMMC

ABAC7284D15

E480

87910-0R210-C0

USD

IB

TMMC

ABAC7284D15

G464

87940-0R190-A0

USD

IB

TMMC

ABAC7284D15

E402

87940-0R190-B1

USD

IB

TMMC

ABAC7284D15

E134

87940-0R190-B2

USD

IB

TMMC

ABAC7284D15

G337

87940-0R190-C0

USD

IB

TMMC

ABAC7284D15

G497

87940-0R190-D1

USD

IB

TMMC

ABAC7284D15

G883

87940-0R190-K0

USD

IB

TMMC

ABAC7284D14

E551

87910-0R210-C0

USD

IB

TMMC

ABAC7284D14

F260

87910-0R210-B0

USD

IB

TMMC

ABAC7284D14

E636

87940-0R190-B2

USD

IB

TMMC

ABAC7284D14

G537

87940-0R220-A1

USD

IB

TMMC

ABAC7284D14

G657

87940-0R190-K0

USD

IB

<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>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]1[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]83.1808[/TD]
[TD="align: right"]83.3021[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]38.9443[/TD]
[TD="align: right"]38.8914[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]37.7509[/TD]
[TD="align: right"]38.2813[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]4[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]37.7509[/TD]
[TD="align: right"]38.2813[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]5[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]37.7509[/TD]
[TD="align: right"]38.2813[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]7[/TD]
[TD="align: right"]268451[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268451[/TD]

[TD="align: right"]38.9443[/TD]
[TD="align: right"]38.8914[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]8[/TD]
[TD="align: right"]268451[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268451[/TD]

[TD="align: right"]43.1304[/TD]
[TD="align: right"]43.6608[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]9[/TD]
[TD="align: right"]268451[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268451[/TD]

[TD="align: right"]43.1304[/TD]
[TD="align: right"]43.6608[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]10[/TD]
[TD="align: right"]268451[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268451[/TD]

[TD="align: right"]43.1304[/TD]
[TD="align: right"]43.6608[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]11[/TD]
[TD="align: right"]268451[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268451[/TD]

[TD="align: right"]43.1304[/TD]
[TD="align: right"]43.6608[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]12[/TD]
[TD="align: right"]268451[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268451[/TD]

[TD="align: right"]43.1304[/TD]
[TD="align: right"]43.6608[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]13[/TD]
[TD="align: right"]268451[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268451[/TD]

[TD="align: right"]43.1304[/TD]
[TD="align: right"]43.6608[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]14[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]15[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/9/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]14.2154[/TD]
[TD="align: right"]83.3021[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]16[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/9/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]65.1232[/TD]
[TD="align: right"]38.8914[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]17[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/9/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]14.6445[/TD]
[TD="align: right"]38.2813[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]18[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/9/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]78.1258[/TD]
[TD="align: right"]38.2813[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]19[/TD]
[TD="align: right"]268450[/TD]
[TD="align: right"]7221[/TD]

[TD="align: right"]10/9/2017[/TD]
[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]268450[/TD]

[TD="align: right"]46.4878[/TD]
[TD="align: right"]38.2813[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]83168[/TD]

</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
87910-0R210-C0
87910-0R210-C0
87910-0R210-C0
87910-0R210-B0
87910-0R210-B0

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 105px;"><col style="width: 68px;"><col style="width: 56px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]22[/TD]

[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]83.1808[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]23[/TD]

[TD="align: right"]10/7/2017[/TD]
[TD="align: right"]38.9443[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]24[/TD]

[TD="align: right"]10/9/2017[/TD]
[TD="align: right"]14.2154[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]25[/TD]

[TD="align: right"]10/6/2017[/TD]
[TD="align: right"]38.9443[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]26[/TD]

[TD="align: right"]10/9/2017[/TD]
[TD="align: right"]65.1232[/TD]

</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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

i​

[/TD]
[TD]

j​

[/TD]
[TD]

k​

[/TD]
[TD]

l​

[/TD]
[TD]

m​

[/TD]
[TD]

n​

[/TD]
[TD]

o​

[/TD]
[/TR]
[TR]
[TD]

20​

[/TD]
[TD]

22​

[/TD]
[TD]87910-0r210-c0[/TD]
[TD]

10/6/2017​

[/TD]
[TD]

83.1808​

[/TD]
[TD][/TD]
[TD]87910-0r210-c0[/TD]
[TD]

14.2154​

[/TD]
[/TR]
[TR]
[TD]

21​

[/TD]
[TD]

23​

[/TD]
[TD]87910-0r210-c0[/TD]
[TD]

10/7/2017​

[/TD]
[TD]

38.9443​

[/TD]
[TD][/TD]
[TD]87910-0r210-b0[/TD]
[TD]

65.1232​

[/TD]
[/TR]
[TR]
[TD]

22​

[/TD]
[TD]

24​

[/TD]
[TD]87910-0r210-c0[/TD]
[TD]

10/9/2017​

[/TD]
[TD]

14.2154​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

23​

[/TD]
[TD]

25​

[/TD]
[TD]87910-0r210-b0[/TD]
[TD]

10/6/2017​

[/TD]
[TD]

38.9443​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

24​

[/TD]
[TD]

26​

[/TD]
[TD]87910-0r210-b0[/TD]
[TD]

10/9/2017​

[/TD]
[TD]

65.1232​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!!