I guess you want to know which functions don't work with arrays. I don't
know of a list.

RANK

There's a lot of them in the Analysis ToolPak add-in. Here's a few:

WEEKNUM
ISODD
ISEVEN
NETWORKDAYS

Just a thought on the general subject of functions...

It would seem to me that developing functions is probably the easiest thing
to do in terms of the Excel application development as a whole. Yet, new
and/or improved functions are rare and few when new versions of Excel are
released. Each new release of Excel seems to be geared more towards data
presentation than data analysis.

--
Biff
Microsoft Excel MVP


"Greg Lovern" wrote in message
...
Are there other functions besides CONCATENATE, AND, & OR that are not
array-aware but also are not scalar (returning a single result for
multiple inputs, such as SUM, MAX, COUNT, etc., and therefore would
not benefit from being array-aware)? Is there a list of them out there
somewhere?

Greg


T. Valko wrote:
You're preaching to the choir!