try this
go to data
sort
col B
assending or dessending as u wish......... try this

second one is

give column heading and put in pivot table there also u will get ......
what u r expecting

thank u

"Mike Moore" wrote:

I have two columns of data. Column A contains a product's description.
Column B contains a stock number.

Column A (product description) will have descriptions that repeat several
times (repetition will not be in any sort order). Column B's will be unique
(i.e. there are no repetitions).

I need help with a formula that will extract the stock numbers of the first
3 occurances that match a specified product description.

For example - raw data

Shoes XY123
Gloves GL321
Shoes XY124
Mask MA456
Shoes XY125
Belt BE987
Shoes XY126
Socks SO555
Shoes XY127

The formula would extract and place in column A (new tab):

Row 1 XY123
Row 2 XY124
Row 3 XY125

Thanks!