| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing dientical part numbers but with different prices
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching upc numbers and prices | Excel Discussion (Misc queries) | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
| Comparing two spreadsheets part 2 | Excel Worksheet Functions | |||
| excel 2003 help comparing prices for lowest | Excel Worksheet Functions | |||
| I am trying to round a list of numbers (prices) to xx.95. Is the | Excel Worksheet Functions | |||
Threaded Mode
