return selected Cell ; minimze function

Hello everybody,

I am facing the following problem; but i am not sure if it is even possible.
within excel I made a double MIN function for example :

Min ( Min( A1 + A2; A3 +A4 ); min (B1+B2; B3+B4) ).

The answer for instance gives me the value 8 because

However i want to know which combination generated 8. Is there a method so that i can get a report that the answer was for instance generated by B1+B2

Thanks in advance

Tom

It is a good solution. However my double min function is much bigger than stated over here so it would be take to much time;

Thanks anyway.

Originally Posted by popipipo

I don't think that make any difference

Agreed.

If the 'simplfied' version is an accurate represantation of what the 'real' version does, then the logic is sound.
There's no need to NEST Min functions.

Anyway, posting simplified versions of a formula is usually not a great idea.
Solutions to the 'simplified' version are often difficult or impossible to apply to the 'real' version.

I'd suggest posting a sample book with a realistic sample of data, and your expected results.

I see; i noticed that i stated the problem in a slightly different way; in that case it is not possible to do so.