Populate Text Based on Max Value

Mallory McFall

Hello,

I need a formula that will return the name of the vendor with the most votes for each user.

Thank you!

Mark Cronk

Hi @Mallory McFall ,

I can't see your column names or row numbers so you'll need to adjust but try:

=JOIN(COLLECT(Vendor1:Vendor4, [John Smith]1:[John Smith]1, MAX([John Smith]1:[John Smith]4)),"-")

This assumes the column with you vendors is [Vendor] and Vendor 1 is in Row 1; Vendor 4 in Row 4. And, that the users name is the column name for them.

If more than 1 vendor has the most votes it will return them all with a"-" between the names.

Help at all?

Mark

Mark Cronk

Hi @Mallory McFall ,

I can't see your column names or row numbers so you'll need to adjust but try:

=JOIN(COLLECT(Vendor1:Vendor4, [John Smith]1:[John Smith]1, MAX([John Smith]1:[John Smith]4)),"-")

This assumes the column with you vendors is [Vendor] and Vendor 1 is in Row 1; Vendor 4 in Row 4. And, that the users name is the column name for them.

If more than 1 vendor has the most votes it will return them all with a"-" between the names.

Help at all?

Mark

Mallory McFall

All of your assumptions were correct! I modified the view for privacy purposes. Thank you so much for your help!

Mark Cronk

Happy to help. Thanks for using the Community.

Be Well,

Mark