Forum Discussion
Compare and replace
Hi Guys I have a messy data set, 3000+ rows, and I must compare columns M and Q. Where Q is different to M, Q needs to be the value captured in M. Or if easier the correct value could go to a new ...
Hi, Thank you for your help. It didn't quite work. I copied it into row T and it picked up the address in Q, which I want where they differ from M, But it only gave me a 0. I have tried swapping the cell values around but I only get either all of M or all of Q with 0 values. I have tried trying to get that to the reference M2 but to no avail. Would appreciate any further help you can give me.
I am not great with this sort of thing. Punching above my weight here:(
Cheers
I Think i got it sorted. I had to use IFERROR. Had to do it twice to get it to return a #value instead of a 0
=IFERROR(IF([@Column1],[@billingstreet],[@billingstreet]),[@Column1])
Thanks Heaps
=IFERROR(IF([@Column1],[@billingstreet],[@billingstreet]),[@Column1])
Thanks Heaps
- Thank you for your feedback.
I am pleased that you have found a solution for your project.
I wish you continued success with Excel.
