#### Harry0

##### Member

instead of laying out a big chart of 100000 results and scan though them, anyway to make a row of a few hundred or less to scan thousands of formulas for the best result without showing every possibility on screen but to look for it?

or in other words for example

if row A1 selects which % to look for from A3 to B100 , and A2 shows what overall amount of likelihood it has to show it.

So instead of putting every possible % in A1 manually any way to find what is the best automatically to get the best # for A2?

If a2 is the best number then dont calculate another number for a1

Since what if

a1 = 1% and a2 = 50% which is not as good as

A1 =5.5% and a2 = 90% which is a better result

thanks