Hello all! I have searched for a way to even ask this, but I keep finding answers on how to sum data by groups. That is not what I'm looking for. The best way to explain what I need is with a sample data set. Let's say I have some numbers in a range: 1,2,3,3,3,4,4,5,5,6,8,9,9. I am looking for a way to find out how many groups of 10 (or near 10) this set can make. Each number in the set would only be used once.
1+9
2+8
3+3+4
4+6
5+5
3
9
So this set would result in 7. There are 5 full 10s, and the remaining 9 and 3 can't be matched with anything else, so they each get their own group. I am self-taught intermediate in Excel, and not afraid to turn to VBA if needed, I just don't really know where to start here. I'm figuring it will involve an array formula, which I have not had the occasion to use often. This is an extremely simplified version of what I am actually trying to do, but if somebody can get me this far I can figure out how to apply it to my actual issue. Thank you in advance for the assist!
Bookmarks