In excel 2003 if working with a data base and you want multiple answers you
get an error with the dget function. In excel 3 there was an extract function
that would give you multiple answers without getting an error. Is there a
similar function in excel 2003.
--
kiteboy

I think Extract was replaced by Data--Filter or Data--Advanced Filter?

Or you could use an array formula.


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"kiteboy" wrote in message
...
In excel 2003 if working with a data base and you want multiple answers
you
get an error with the dget function. In excel 3 there was an extract
function
that would give you multiple answers without getting an error. Is there a
similar function in excel 2003.
--
kiteboy