Thread
:
Permutations
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
John[_33_]
external usenet poster
Posts: 2
Permutations
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
Reply With Quote
John[_33_]
View Public Profile
Find all posts by John[_33_]