Identify the numbers that make up the average
 

the Range A1:A100 has numbers starting from 1 to 100.

Hi. If you just had the numbers 1-20, and wanted to find those cells
that average 10 (ie half the upper limit), then I believe there are
29,503 possibilities. It's a very large number if you have 1-100, and
want to find the number of combinations that average 50.

Dana DeLouis



Hi Macropod,

Thanks for that link. it's a great start.

Regards,
-- Tausif Mohammed "macropod" wrote:
Hi Tausif,

You could try a variation of the code i Posted he
http://www.tek-tips.com/viewthread.cfm?qid=1485698
That code retrieves cells containing numbers that sum to a value,
but you could modify it to retrieve cells containing numbers that
average a value.

--
Cheers
macropod
[MVP - Microsoft Word]


"Tausif" wrote in message
...
Hi Jacob,
Thanks for your reply.

The number in B2 is hardcoded i.e no formula used. Basically I
have a list
of such numbers which I get via a spreadsheet. So unfortunately,
the Trace
Precedents option will not work here.

Regards

--
Tausif Mohammed


"Jacob Skaria" wrote:

Dear Tausif

Select the cell and from the Formula Audtiing Toolbar click
'Trace Precedents'

View|Toolbars|Formula Auditing

If this post helps click Yes
---------------
Jacob Skaria


"Tausif" wrote:

Hi,

I require to identify which numbers make up an average of
the number that is
in a particular cell.

eg) Cell B2 has a number which is 2 (This number is is the
average of
numbers 1+2+3)

the Range A1:A100 has numbers starting from 1 to 100.
Does excel provide a way to identify what combination of
the numbers in the
range A1:A100 would provide me the number 2.

Hope I have been clear.

Bests

--
Tausif Mohammed