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