•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
My Father is Planning a Golf Game
My father is attempting to implement a golf game using Excel, but is struggling to make his plan work in Excel so it can be deployed. He has two columns, A and B. Four rows 1-4. Each cell has a number and some numbers can be duplicates. He wants the lowest sum of three numbers. They must come from different rows and one number must be in column A.
He is attempting to make this work using functions such as CHOOSE, INDEX, MAKEARRAY, etc. The only way he can get this to work is a lengthy nested if statement. He is under the assumption that there is a better way to get this done.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#golf game
#Excel
#numbers
#functions
#columns
#rows
#lowest sum
#sum
#CHOOSE
#INDEX
#MAKEARRAY
#nested if statement
#duplicates
#different rows
#plan
#cell