Finding N numbers in column to achieve desired value

**art1985** · 10-03-2018, 05:05 PM

Hi
I have numbers in columns A:C and E. I want to choose any combination of three numbers from the array of numbers in A:C (including repeats) that when averaged equal one of the value in Column E.

I then want to display the three numbers that I used in the next three columns
Untitled.jpg

**Kaper** · 10-04-2018, 04:01 AM

Try such code:

Please Login or Register  to view this content.

Note that because you are working with floating point numbers (not just mathematical Real numbers), the accuracy of computations is not perfect.
So just checing equality can sometimes return wrong results. Thatls why I'm checking if the difference is smaller than some acceptable inaccuracy.

Just as a proof: ry writing in A1:A100 values 0.1 and in B1:

Formula:

Please Login or Register  to view this content.

It's not 0, is it?

Finding N numbers in column to achieve desired value

LinkBack

Thread Tools

Rate This Thread

Display

Finding N numbers in column to achieve desired value

Re: Finding N numbers in column to achieve desired value

Thread Information

Users Browsing this Thread

Similar Threads

Netting out positive and negative numbers to achieve closest to 0

inserting empty cells to achieve matching numbers across two columns

[SOLVED] Alter given values to achieve desired result

Finding the top five numbers in a column that has 2 seperate ranges of numbers/data sets

[SOLVED] IF formula with certain conditions to achieve a desired value

Finding multiple cells that add up to a desired amount

Excel 2007 : calculating numbers needed to achieve best result

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions