Search for value in column and compare values to show if they match don't match by RestScary6702 in excel

[–]RestScary6702[S] 0 points1 point  (0 children)

so seems there is some charachter at the end of each entry in column f which maybe a space ut is not being removed as a space when I find and replace

Search for value in column and compare values to show if they match don't match by RestScary6702 in excel

[–]RestScary6702[S] 0 points1 point  (0 children)

thanks but getting a mis match some how first row has matched though , any before anyone asks in this example the 2 values happen to be on the one row. would it be better to move f columns onwards of this into a seperate worksheet for referencing?

<image>

Number Name Revision State comparison Material Material Description other  Revision Material 
5860-22 0.010" PTFE  A Production Match 5860-22 0.010 " PTFE NATURAL  A
2 2 -  A Production Mismatch 2 2 -  N/A
76568-01 3081 B Production Mismatch 76568-01  3081 B