I need a formula that will return the text "CP" in a new column if one or more of the preceding columns have any value in them at all.
I have attached a sample workbook, sheet 1 being the info i have and sheet 2 being what it needs to look like.
So basically, if the part number in column 1 is in any of the boxes it has a number stating how many times it appears in that box, i need the formula to check if the part number appears in more than one box and then place in the last column "CP" (common part). this is for massive amounts of rows of data so we need to be able to quickly scroll through and see what parts are common across boxes.
if a part number only appears in one box then there wont be "CP" as its not part of any other box.
the amount it appears in each box doesn't matter at all, just need to know that it appears in multiple boxes
really hope that makes sense.... haha
Example Sheet.xlsx
Bookmarks