Check if Data not unique, and show results

[Chantal4130]

Hi,

Any help with this would be really appreciated.

I have a table where it lists products in Column A and there price in Column B.
Using this data I want to be able to List all Products where there is Inconsistent Pricing for the same item.

Example: In the below there is a total of 3 of 'Item 1' but there price is not the same. I want to display in another column the list of products where the Item of the same name has more than 1 different price. and basically do this for each item.

Please see example attached.

Product Price
Item 1 100
Item 1 200
Item 1 100
Item 2 20
Item 2 20
Item 3 90
Item 3 43
Item 4 26
Item 4 26
Item 4 26


Thanks

[Special-K]

Try

in C1
=IF(COUNTIF(A$1:A$10,A1)=COUNTIFS(A$1:A$10,A1,B$1:B$10,B1),"",1)
and copy down

[Chantal4130]

Ahh I see what its doing, Simply putting data in a cell where the Item Price is inconsistent. This works for me .

Thanks Special-K