Array parameters?

**Fat Al** · 02-07-2012, 11:57 AM

Hi folks, new to the forum, could someone please take a look at my problem...

I've attached the Test.xlsx excel file , its easier to explain on the spreadsheet.

Thanks in anticipation

**zbor** · 02-07-2012, 12:03 PM

maybe this:

**Fat Al** · 02-07-2012, 12:16 PM

Originally Posted by zbor

maybe this:

My god! how fast is that?

Great, thank you very much,

could you explain what is happening in cell j9?

**zbor** · 02-08-2012, 03:01 AM

You have criterias in whole 9th row as described below: less than half, hlaf, same etc...
In all of them you have criteria compared to G8 so formula in 11th row can be simplier.

Notice in 9th row is important to have lowest value at the left (0) and highest value at the right (some nnumber that will never exceed... )