| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get DGET to return all records that meet the criteria?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I get DGET to return all records that meet the criteria?
The inherent function of DGET is that if multiple records meet the criteria,
you get the error. Do a search In: Excel Worksheet Functions. Search for: get multiple records. There is a thread titled Using DGET to extract multiple records that you may find useful. (Note: They didn't use DGET). -- John C "Eddie A" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not sure what function to use to return records that fit criteria | Excel Worksheet Functions | |||
| Using DGET to extract multiple records | Excel Worksheet Functions | |||
| Auto-generating a list of records that meet a pattern criteria | Excel Discussion (Misc queries) | |||
| count records which meet filter criteria | Excel Discussion (Misc queries) | |||
| How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
Linear Mode
