M
Martin T
I have two spreadsheets in the same workbook. One is a download with 6000
part numbers in column A, some of which have prices in column B. The second
sheet has less than 1000 of the same part numbers in column A, with new
prices in column B. I want to compare the two and show only the new prices,
they can be in a new column. I am probably being thick, but I can't work out
how to do it.
Sheet 1
Col A Col B
2121-907 0
2121-908 0
2121-909 0
2121-910 0
Col A Col B
2121-907 1.00
2121-909 1.00
2121-910 2.00
Martin T
part numbers in column A, some of which have prices in column B. The second
sheet has less than 1000 of the same part numbers in column A, with new
prices in column B. I want to compare the two and show only the new prices,
they can be in a new column. I am probably being thick, but I can't work out
how to do it.
Sheet 1
Col A Col B
2121-907 0
2121-908 0
2121-909 0
2121-910 0
Col A Col B
2121-907 1.00
2121-909 1.00
2121-910 2.00
Martin T