David -

Difficult to find detailed help on above function. I get this function not
valid, even if entered as an array formula. I have done this once before
and I know I need to select a region, but it still remains confusing. <

It's usually entered using the Data | Table command.

There's considerable Help on the "data table" topic.

- Mike

www.mikemiddleton.com