I am using DGET to search for the greatest price of a product listed in a spreadsheet. Each product will have several days listings and multiple daily listings. My criteria table uses DMAX to retreive the most recent time and date listing from the same spreadsheet. When using products that are similar up to the 15th character I receive a #NUM error message. The specific products are DSL #2 LOW SULF and DSL #2 LOW SULF DYED. Also, when using the FIND function for these products in the spreadsheet column Find Next will stop on both when searching for the shorter product, but when searching for the longer product the search is accurate.
A simple data table is:
Product Price Date
DSL #2 LOW SULF 1.00 6/1/2003
DSL #2 LOW SULF DYED 1.50 6/1/2003
DSL #2 LOW SULF 0.90 6/2/2003 DSL #2 LOW SULF DYED 1.40 6/2/2003
This range is named DATA
A cirteria table of:
Product Date
DSL #2 LOW SULF 06/02/03
This range is named APRODUCT
where date is DMAX(DATA,3,APRODUCT)
Without macros, can I get past the #NUM error message?
A simple data table is:
Product Price Date
DSL #2 LOW SULF 1.00 6/1/2003
DSL #2 LOW SULF DYED 1.50 6/1/2003
DSL #2 LOW SULF 0.90 6/2/2003 DSL #2 LOW SULF DYED 1.40 6/2/2003
This range is named DATA
A cirteria table of:
Product Date
DSL #2 LOW SULF 06/02/03
This range is named APRODUCT
where date is DMAX(DATA,3,APRODUCT)
Without macros, can I get past the #NUM error message?