Advanced MODE function

[JimM]

Hi guys

I need some help with a formula and not sure how to tackle it.

In the below set of data I need another column that will pick out the most common pricing for each product type and put that price against each line

ie if i start with

Product Price

Product1 25
Product1 25
Product2 27
Product3 28
Product4 29
Product1 23
Product1 24
Product2 27
Product2 28


I want to end with

Product Price Mode

Product1 25 25
Product1 25 25
Product2 27 27
Product3 28 28
Product4 29 29
Product1 23 25
Product1 24 25
Product2 27 27
Product2 28 27

Any ideas ?

Thanks

Jim

 

[fuzzballcadillac]

Thank you very much! This worked perfectly.

 

[T. Valko]

Thank you very much! This worked perfectly.

You're welcome. Thanks for the feedback!