Hello!
I'm hoping one of you lovely peeps can help me here. I have a spreadsheet that has cleansed of pre-fix's part numbers in Column B, a duplicate part number warning in Column C and a formula in Column D that says, in English....
If C2 contains "Dupe" then combine the the contents of B2...