This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello, can someone help with a formula that will create a new column that says 'match' as long as the ZIP matches the PIZ and as long as PIZ1 has the same value as ZIP1 just in 1 box. and even if its blank it should also be match
I think i'm almost there but the last row (10) is saying its a match it actually should be a not match. Any ideas? The reason row 7&8 is a match is because Zip column is a match as long as there is a matching Piz anywhere in the column Piz. Hopefully this makes sense.
i did not expect this to be more then a formula, but this works too. I was wondering how i would make it to say changed if Zip and Piz are really different and New if it doesnt match to anything in PIZ.