Thread
:
Add best 6 numbers on a row of 10
View Single Post
04-28-2018, 12:36 AM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,100
Why not 1 1 2 2 2 3 (total 11) from the first row?
If I am right then that's exactly what my formula in #4 does.
=SUMPRODUCT(SMALL(A1:K1,COLUMN($A:$F)))
xor
View Public Profile
Find all posts by xor