Search results

Email has sent, please kindly check. Many thanks.

Narayan, Could I have your email address ? I'll send my workbook to your mail. Thanks

Hi Narayank, It seems like IOANNIS never online since 2007. Do you have his email addres or maybe his workbook?

Thanks Narayank for the information :) I'll contact IOANNIS asap. I'm sorry if I can't apply your last solution neither due to the user needs. They don't want to search it manually again for all possible combination. If you try to delete all the negative values, the possible combination of...

Hi Narayank Thanks for your attention. Yes it is a difficult condition for me to solve. The target values is always that big, and some times in billion values. It was the payment that the customer did. And for the negative value, it can't be remove because it is the overpaid value that I...

Thank you All for your advice. I have tried all you solution before, and yes they worked. But unfortunately, I can't use them. Because as I mention above, the data should be ordered by the date which mean the negative value can be in the middle of the line. And I'm just want to find the first...

I'm sorry but I still confuse here. Would you please to try with my data example below, and I only want to find the first combination. Example: -Target value : 120,662,010 -Data: (106,623) 117,720 3,125,340 3,757,320 2,984,220 7,549,020 805,140 5,177,700 (649,800) 10,437,660...

Hi I need your big help here. I have a set of data in a column which have vary numbers, both positive or negative values. What I want to do is to find the match combination of that data which sum to a target value. For example in column A has value which range is from -3 to 500, and I...