Formula to update a value automatically
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.
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?
Help Article Resources
Check out the Formula Handbook template!