See:
http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu201001
"John" wrote:
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