LinkBack URL
About LinkBacks
Help, my mind has went blank! - I"ve done this before but can't remember how?
I need to compare two columns and highlight or show the differences somehow... workbook with example attached.
Many Thanks
Help, my mind has went blank! - I"ve done this before but can't remember how?
I need to compare two columns and highlight or show the differences somehow... workbook with example attached.
Many Thanks
A B C D Value Mark Compare 4 RU.LNG.010RV-061A-SV - RU.LNG.010RV-061D-SV 5 RU.LNG.010RV-061B-SV - RU.LNG.010RV-061S-SV 6 RU.LNG.010RV-061C-SV - RU.LNG.010RV-081-SV 7 RU.LNG.010RV-061D-SV 1 RU.LNG.044RV-021A-SV 8 RU.LNG.010RV-061S-SV 1 RU.LNG.044RV-021S-SV 9 RU.LNG.010RV-081-SV 1 RU.LNG.044RV-022-SV 10 RU.LNG.044RV-021A-SV 1 RU.LNG.044RV-031A-SV 11 RU.LNG.044RV-021S-SV 1 12 RU.LNG.044RV-022-SV 1 13 RU.LNG.044RV-031A-SV 1 14 RU.LNG.044RV-031S-SV - 15 RU.LNG.044RV-041A-SV - 16 RU.LNG.044RV-041S-SV - 17 RU.LNG.046RV-501-SV - 18 RU.LNG.046RV-502-SV - 19 RU.LNG.046RV-503-SV - C4 Fill-Down =IF(ISERROR(MATCH(B4,$D$4:$D$19,0)),"-",1)
FrankBoston is the pen name for Andrew Garland, Lexington MA
Thanks that'll do fine - I was sure I did it before with conditional formatting, but have tried and just can't work it out...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks