
New Member

March 8, 2019

HI Guys
i have a spreadsheet that looks like this
A B
C001 Value 1
C001 Value 1
C001 Value 1b
C002 Value 3
C002 Value 3
C003 Value 3b
C004 Value 4
What i am trying to achieve is a script that will look at the first Column A value - and will compare it to each Column B value UNTIL there is a change in Column A and then start again ......so the net result would be
A B C
C001 Value 1 ok
C001 Value 1 ok
C001 Value 1b different
C002 Value 3 ok
C002 Value 3 ok
C003 Value 3b different
C004 Value 4 ok
Any thoughts on how to achieve this???

VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016

Hi Adrian
It doesn't matter how many rows you have.
In cell C2 enter ok.
In cell C3 enter =IF(C2="different","ok",IF(A3&B3=A2&B2,"ok","different")) and then double click on the bottom right corner of C3 (where a tiny black square appears) to copy (fill) the formula downwards.
I did note that your data is not "clean". For eg. cell B37. It looks similar to B36 but there is an extra space after the letters pF. This can cause erroneous result. You may need to remove such spaces for the formula to work correctly.
Sunny
1 Guest(s)
