Values that could summarize specific criteria

  • Thread starter Thread starter jacpardo
  • Start date Start date
J

jacpardo

Hi, thanks for your help

I have a list of values, and I need to find the value or values tha
could summarize specific criteria

Example:

Column A
100
-9.96
-262.55
-133.57
-212.82
-17.62
-149.42
-6.84
-90.02
-370.37

I need to find which values could summarize -51.19

In this case the answer is
100
-133.57 and
-17.62

Is there any formula that can help me
 
Hi
no there's no such formula. Some questions:
- how many rows of data do you have
- do you only need one result or all possible results

Note: Depending on the amount of values you have to check this maybe
not feasible due to calculation times (to many possible combinations to
check)
 
Thanks Frank for your attention

Actually I have to consider more than 200 rows of data. I was tryin
to make some kind of macro that can help me, but the combinations a
you say are difficult.

About the second question, I need all the possible results.

Regard
 
Back
Top