in excel 2003 what is the replacement for the old extract formul?

  • Thread starter Thread starter kiteboy
  • Start date Start date
K

kiteboy

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open an Excel file each time the computer is booted 2
Macro Excel 2003 1
Find/Replace MSWord wildcard characters from within Excel 6
Porting from Excel 2003 to Excel 2010 12
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Extracting Excel2007 data from structured Storage 0
In VBA, check if file is corrupt or not Excel 5
Autofilter of Protected Sheet - Excel 2000 (not 2003 or 2007) 2

Back
Top