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
maybe this:
Last edited by zbor; 02-07-2012 at 11:05 AM.
"Relax. What is mind? No matter. What is matter? Never mind!"
Re: Array parameters?
My god! how fast is that?Originally Posted by zbor
Great, thank you very much,could you explain what is happening in cell j9?
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... )
"Relax. What is mind? No matter. What is matter? Never mind!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks