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
Bookmarks