Results 1 to 3 of 3

DGET - Formula Returns #NUM! Error (I verified no duplicates)

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    Spring, TX
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question DGET - Formula Returns #NUM! Error (I verified no duplicates)

    To anyone that has encountered this issue, (see attached file)
    I am trying to use the database DGET function and I continue to get the error result #NUM! which according to Excel help indicates duplicate values in the database. I reviewed the database by using auto filter on the criteria I entered for the DGET function and only 1 record is returned. So, how can there be a duplicate? I have also had bad results using the DSUM function especially when the criteria has similar items in the field but not a redundant item. Any help would be much appreciated.
    Attached Files Attached Files
    Regards,

    Wally

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1