Excel Formulas - using simple VLookup for invoice

[37no37]

given 24 numbers, (97,101,139,41,37,31,29,89,23,­19,8,13,131,19,73,97,19,139,79­,67,61,17,113,127)taken 5 at a time, generate the unique combinations add up to 200. so, num combination to test 42504, optimal results 27 groups of 5 numbers : example (8-17-37-41-97)-(8-13-37-41-10­1)

etc. this program is in java. How is possible to do this in EXCEL 2003 .

[37no37]

combinatorial problem -- given the 24 numbers taken 5 at a time, which unique combinations add up to 200?

[dsqraj]

Very useful..Thanks

[MrKassemkabbani]

what happens if you sell widgets and spanners in the same order #?? how can i get that information?

[lickspitle]

Brilliant, well explained, thank you so much

[BinVin100]

Thank you, this helped me out a great deal!!! Cheers!

[Nanch833530]

or press F4 to fix the range instead of hard coding the $ sign

[CrazyRubberDuck]

Thanks SOOOOO much! you just helped me massively on my IT homework :-D

[godrumo]

You are a legend. Thanks mate

[MAHESHD28]

Its a nice information

[aderator]

Really useful. Thanks very much.