pagination1
New Member
- Joined
- Apr 24, 2012
- Messages
- 48
Hi there,
I’d be really grateful for your help, as this is driving me mad.
If I have an excel spreadsheet, with, for example,
cells A1:A8 each containing a number from 1 to 8 (eg, A1=1, A2=2, A3=3 etc), how can I do the following:
I would like a formula which can tell me how many FOUR digit combinations there are of the numbers contained in A1:A8 BUT, the four digit combinations produced by the formula must total 15 exactly. No more, no less.
Does anyone have an idea what on earth this formula might be?
I’ve spent hours trying to figure it out, but I just can’t work it out.
Thank you so much in advance for your help!
I’d be really grateful for your help, as this is driving me mad.
If I have an excel spreadsheet, with, for example,
cells A1:A8 each containing a number from 1 to 8 (eg, A1=1, A2=2, A3=3 etc), how can I do the following:
I would like a formula which can tell me how many FOUR digit combinations there are of the numbers contained in A1:A8 BUT, the four digit combinations produced by the formula must total 15 exactly. No more, no less.
Does anyone have an idea what on earth this formula might be?
I’ve spent hours trying to figure it out, but I just can’t work it out.
Thank you so much in advance for your help!