Excel matching and comparing -

so seems bit perplexing me being i'm new excel.

i have one-to-many relationship sku , part#.

i want see if each parts' price equal each other, if share same sku #.

and, if not same price, return result of essentially, "different price".

sku#           part#    price  1000-002-581   56465    12800 1000-002-581   800335   13300 1000-002-582   56455    12800 1000-002-582   800325   13300 1000-002-584   56445    12800 1000-002-584   800315   13300 

above results have.

i.e. sku 1000-002-581 has part #: 56465 , 800335. , price each part different (12800 vs 13300). want retrieve message because different.

at end of day, want display lines part price differences each associated sku.

any thoughts on collective functions work?

add column table formula

=if(sumif(a:a,a2,c:c)/countif(a:a,a2)<>c2,"different","") 

turn on autofilter , filter last column.