Wow Grizz!
No wonder, why I was clueless about how to do it. I will have to spend time on analyzing your elegant solution. But until then, would you please, explain to me just one thing:
According to Excel help, the syntax of the function Index can be either 3 or 4 items in a bracket but your solution contains only two:
a range and a Match expression. How about that?
It's true, that the Match expression contains 3 items but I am assuming that the result of the Match expression is only one item, so that's why I am puzzled a bit here.
As I said, I will definitely have to learn how to use the Index and Match (one at a time), but without your answer, I could not figure out the mismatch in the required number of items in your Index expression.
|