| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare Duplicates
Hi, I have 10,000 sku numbers in Column A with their Prices in Column
B. What I would like to do is to find duplicate sku numbers and then compare those duplicate sku's to see if they have the same price in Column B. Any suggestions would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare Duplicates
I think Pivot table would help you alot in this case.
" wrote: Hi, I have 10,000 sku numbers in Column A with their Prices in Column B. What I would like to do is to find duplicate sku numbers and then compare those duplicate sku's to see if they have the same price in Column B. Any suggestions would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare Duplicates
Try to summerize by sku in a pivot table
" wrote: Hi, I have 10,000 sku numbers in Column A with their Prices in Column B. What I would like to do is to find duplicate sku numbers and then compare those duplicate sku's to see if they have the same price in Column B. Any suggestions would be appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare Duplicates
thanks, I will try that.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to compare two columns and remove duplicates? | Excel Discussion (Misc queries) | |||
| Compare the 1st 9 digits in two columns looking for duplicates | Excel Worksheet Functions | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
| compare numbers and mark duplicates | Excel Discussion (Misc queries) | |||
| compare two columns and remove duplicates | Excel Worksheet Functions | |||
Linear Mode
