Comparing values in a column

[Redsox]

Hello!

I have a price column and a product column in an Excel Worksheet. There are many of the same products, but some of the products with the same name have different prices. I want Excel to find the majority price and mark or find the prices that are different (not part of the majority). Is this possible? Thanks for the help in advance!!!

[jason.b75]

Based on products in A2:A100 with prices in B2:B100, in C2 enter the following formula

=MODE(IF(A2=A$2:A$100,B$2:B$100))

which must be array confirmed using Shift Ctrl & Enter, not just Enter. Use autofill to populate the rest of column C, this will list the majority prices.

Next use conditional formatting and apply a rule using the formula =$B2<>$C2 to highlight rows where the price in column B differs from the majority price returned by the array formula in column C.