L
lputnam
I need to compare cells 2 columns and return a value if different.
e.g.
A1: 2002 B:2002
A2: 2002 B:2003
A3: 2002 B:2002
Need to identify row 2 is different (with an x and a color?) I have about
1000 rows to compare.
I tried some of the formulas listed in this section e.g.
=if(countif(a:a,a25)>1,a25,"")
but didn't return what i wanted.
e.g.
A1: 2002 B:2002
A2: 2002 B:2003
A3: 2002 B:2002
Need to identify row 2 is different (with an x and a color?) I have about
1000 rows to compare.
I tried some of the formulas listed in this section e.g.
=if(countif(a:a,a25)>1,a25,"")
but didn't return what i wanted.