Formula to update a value automatically

Denise Drinkard

I have 5 rows. The value for each can be low, medium, or high.

If the majority of the rows is one of the values then I want row 6 to return that value. But if any of the rows are high Row 6 value should be high.

Example:

Row1--Medium, Row2--High, Row3--Medium, Row4--Low, Row5--Low., Since Row2 is High Row 6 value is High

If Row2 value was Medium, then Row6 value would be Medium.

any idea on a formula to do this automatically?

Paul Newcome

Try this...

=IF(CONTAINS("High", [Column Name]1:[Column Name]5), "High", IF(COUNTIFS([Column Name]1:[Column Name]5, "Low") > COUNTIFS([Column Name]1:[Column Name]5, "Medium"), "Low", "Medium"))

Denise Drinkard

THANK YOU!!!....been racking my head on that one. works perfect

Paul Newcome

Try this...

=IF(CONTAINS("High", [Column Name]1:[Column Name]5), "High", IF(COUNTIFS([Column Name]1:[Column Name]5, "Low") > COUNTIFS([Column Name]1:[Column Name]5, "Medium"), "Low", "Medium"))

Denise Drinkard

THANK YOU!!!....been racking my head on that one. works perfect

Paul Newcome

Happy to help. 👍️