austenr
08-24-2005, 06:48 AM
Hi everyone,
I have a file that I need to compare. I need to compare columns B and G. The number in column G can occure anywhere in the column. If a match is found I need the value in cell A moved to the matched number in column F. I have attached a spreadsheet with an example. Thanks for your help.
I have a file that I need to compare. I need to compare columns B and G. The number in column G can occure anywhere in the column. If a match is found I need the value in cell A moved to the matched number in column F. I have attached a spreadsheet with an example. Thanks for your help.