Identify the numbers that make up the average

  • Thread starter Thread starter Tausif
  • Start date Start date
T

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
 
Dear Tausif

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

View|Toolbars|Formula Auditing

If this post helps click Yes
 
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
 
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top