View Single Post
 
Old 06-02-2017, 04:48 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

First extract the unique part numbers, using Advanced Filter (Data Menu) to another area, say column F.

Once you have the unique parts in Column F, then in G2 enter formula:

=IFERROR(INDEX($B$2:$B$24,SMALL(IF($A$2:$A$24=$F2, ROW($A$2:$A$24)-MIN(ROW($A$2:$A$24))+1),COLUMNS($G1:G1))),"")


Adjust ranges to suit (don't use ranges larger than necessary).

Then confirm the formula with CTRL+SHIFT+ENTER not just ENTER.

Copied down and across as far as needed to get all the data.
Reply With Quote