Posted to microsoft.public.excel.worksheet.functions

John[_33_] John[_33_] is offline

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
permutations	art	Excel Worksheet Functions	1	May 8th 09 05:07 PM
Permutations	Dave	Excel Discussion (Misc queries)	5	July 23rd 07 03:06 PM
permutations	newyorkjoy	Excel Discussion (Misc queries)	3	November 1st 05 08:20 PM
Permutations	RedChequer	Excel Worksheet Functions	9	September 26th 05 03:14 AM
Permutations	RedChequer	Excel Worksheet Functions	2	September 25th 05 04:05 AM

All times are GMT +1. The time now is 04:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us