Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help need on VBA code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help need on VBA code
Shane,
You don't need VBA. Put this in B1 and copy down =MATCH(A1,$A$1:$A$100,0) -- HTH RP (remove nothere from the email address if mailing direct) "Shane" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
option buttons run Click code when value is changed via VBA code | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |