Identify the numbers that make up the average

[Tausif]

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

 

[Jacob Skaria]

Dear Tausif

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

View|Toolbars|Formula Auditing

If this post helps click Yes

 

[Tausif]

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

 

[macropod]

Hi Tausif,

You could try a variation of the code i Posted here: 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.

 

[Tausif]

Hi Macropod,

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

Regards,
--
Tausif Mohammed

Hi Tausif,

You could try a variation of the code i Posted here: 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]

 

[Dana DeLouis]

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,

Hi Tausif,

You could try a variation of the code i Posted here: 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]

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


:

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


:

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