![]() |
Please Help me With DGET
I'm familiar with how to use DGET, where I have a database setup, and I can retrieve an entry based on matching parameters. However, I can only get it to return one entry. How would I make it so DGET will return every entry rather than#NUM! when there is more than 1 matching entry? -- uscx1 ------------------------------------------------------------------------ uscx1's Profile: http://www.excelforum.com/member.php...o&userid=32324 View this thread: http://www.excelforum.com/showthread...hreadid=520816 |
Please Help me With DGET
Instead of DGET, you could use an Advanced Filter to return matching
records. There are instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html uscx1 wrote: I'm familiar with how to use DGET, where I have a database setup, and I can retrieve an entry based on matching parameters. However, I can only get it to return one entry. How would I make it so DGET will return every entry rather than#NUM! when there is more than 1 matching entry? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com