Identify the numbers that make up the average

[tausif82]

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

[Dr.K]

You have not. You might want to post your workbook so we take a look.

Also, sounds like you are asking for the impossible... once you've got an average number, you can't "go backwards". Any numbers you come up with will be guesses, as there are infinite combinations of numbers that average out to a given number.