New answers tagged

0 votes

Formula to select the name associated with lowest value from data set & a random name from the lowest options if tied

For the solution you could use a long formula in a single cell or 2 much more understandable formulas in 2 different cells. The solution I propose works for any number of names, not just 4. Assuming ...
user avatar
  • 1,251
1 vote

Automatically Color Series In Chart

The following answer was developed piecemeal and many elements could have been combined to create a more efficient process. However, each of the functions will run standalone and this may assist the ...
user avatar
  • 4,753

Top 50 recent answers are included