Hello MartinW,
From your view, what is the key benefit using array formula for huge database,
at the same time, normal formula also can achieve the same result like array
formula?
Please advice.

By the way, what is IMO stands for?
Wilchong


MartinW wrote:
None, IMO. Array formulae are great in that they can do many
things more efficiently than can be done with normal formula,
However, when you can achieve the same funcionality from
a standard formula it is far better to use that, rather than the array.

I should add that this is not an across board sort of thing.
Each situation needs to be assessed on it's merits depending
on what you have and what you are trying to achieve.

HTH
Martin

This ordinary Excel formula: SUMPRODUCT((x = x )*(y = y)*(z = z),(A:A))
can
[quoted text clipped - 6 lines]
Please advice.
Wilchong

--
Message posted via http://www.officekb.com