How can I get DGET to return all records that meet the criteria?

Posted to microsoft.public.excel.worksheet.functions

Eddie A

external usenet poster

Posts: 1

How can I get DGET to return all records that meet the criteria?

I was able to get this function to work, but it only returns 1 record when
there can be many. If my criteria so happens to be a unique record, it
works. However, if I it has muliple records that match, i get a #NUM! Error.
Help will be greatly appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Not sure what function to use to return records that fit criteria	Roy Bernal	Excel Worksheet Functions	2	June 4th 08 07:25 PM
Using DGET to extract multiple records	Bob	Excel Worksheet Functions	9	February 21st 07 05:20 PM
Auto-generating a list of records that meet a pattern criteria	Jeff Gerke	Excel Discussion (Misc queries)	0	March 23rd 06 11:18 PM
count records which meet filter criteria	AKH	Excel Discussion (Misc queries)	1	October 31st 05 03:54 PM
How do I show number of records that meet criteria filter	CliffD	Excel Discussion (Misc queries)	3	August 22nd 05 01:10 PM

All times are GMT +1. The time now is 03:36 PM.

Menu

About Us