Hey guys, I have a tough one. I have sheet1 that has parts, dates, & colors. this is shown as
6/1/11 33333 grey
6/1/11 12223 red
6/1/11 22222 blue
6/2/11 22222 red
6/2/11 22222 red
6/2/11 33333 yellow
On sheet2 I have all of the part numbers listed & then I have a cell where someone will put in a date. What I want shown next to each part number is what colors were produced on that date for the part
date 6/2/11
12223
22222 blue, red
33333 yellow
can this be done?
6/1/11 33333 grey
6/1/11 12223 red
6/1/11 22222 blue
6/2/11 22222 red
6/2/11 22222 red
6/2/11 33333 yellow
On sheet2 I have all of the part numbers listed & then I have a cell where someone will put in a date. What I want shown next to each part number is what colors were produced on that date for the part
date 6/2/11
12223
22222 blue, red
33333 yellow
can this be done?
Last edited:
