Hi all,

I have the following data in columsn A and B. I would like to know how i can
about placing my curcer on column b and running code which will place first
number in column A against the name in B to achieve one number against each
unique name. Ive highlighted the desired results in column C so you can see
the pattern.

Your help is most appreciated.

a b c
Number name PrimaryNo
1 Black 1
2 Black 1
3 Black 1
4 Black 1
5 blue 5
6 red 6
7 yellow 7
8 Pink 8
9 Pink 8
10 Pink 8
11 Pink 8