Hi everyone,

I have a spreadsheet with a lot of information.

the two columns in question are item number and color.

first 6 rows; r444 item number, different color for all 6

next 13 rows; t555 item number, different color for all 13

next 7 rows: y222 item number, different color for all 6

I would like to have a make a formula where the color corresponding to the first item number in the set of same item numbers is the same for the balance of the set.

i.e. Present: r444:blue, r444;yellow, r444;black
Would like to get it: r444;blue, r444;blue, r444;blue

There are other columns not effecting this action that are unique to each row.

Thank You for all of your help!

Robert Haas