Permutations

J

John

Hi,
Is it possible show/highlight the different permutations for the cells which
add up to a determined value.

i.e

Value to find=300
Answer A3 or A2+A1

A
1: 100
2: 200
3: 300
4: 400
5: 500

Regards

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hlookup and sum noncontiguous numbers 1
Permutations andText to column problem 6
Vlookup or similar 7
summary 1
LOOKUPS USING 2 SETS OF DATA 5
use more than 7 if condition in a cell 8
Two Totals from the same column 2
What should formula look like to define date range on SUMIF 2

Top