Hi all,
I can't imagine that my question is original, but I haven't found an answer searching the messages (prolly using the wrong keywords for my problem). Anyway, I have a number, let's say 30 mio, and I have column with all different kinds of values all way smaller than 30 mio, let's say 301 k is the largest and the smallest is 1k. How do I make a formula that adds up the numbers from to match 30 mio exactly or just as near as possible?
Thank you so much & take care,
Karel
I can't imagine that my question is original, but I haven't found an answer searching the messages (prolly using the wrong keywords for my problem). Anyway, I have a number, let's say 30 mio, and I have column with all different kinds of values all way smaller than 30 mio, let's say 301 k is the largest and the smallest is 1k. How do I make a formula that adds up the numbers from to match 30 mio exactly or just as near as possible?
Thank you so much & take care,
Karel
