In Excel (Apple numbers), need a formula to look at 4 cells, in 20 different rows (so 80 cells total), and identify the 3 cells that contain the highest numeric values, and then for those 3 cells, each has a different cell to look to if it was one of the top 3, and then taking those 3 numbers in the referenced cells and producing a result based on a rule as to what numbers are in the 3 referenced cells. This same type of formula would need to be modified 3 more times to do the same, but for top 5, 10 and 15 cells. Also would need to replicate each formula a few times just to change rows being looked at for cells.
Hello, I am Excel and VBA expert. Can I see the file? What is rule to produce a result "on those cells"? Please note that I have 100% completion rate and 5-star feedback on 50 projects.