DGet function

  • Thread starter Thread starter Jim H
  • Start date Start date
J

Jim H

Is there a function or technique that behaves like the DGET
function but is able to return multiple values that match
the criterion instead of just one.
 
Advanced filter is one technique,it is also similar to DGET the way it is
set up.
There are some fairly complicated formulas using a combination of
index and small that you can use to extract multiple hits...
Also the autofilter could probably be used in most cases..
 
Jim H said:
Is there a function or technique that behaves like the DGET
function but is able to return multiple values that match
the criterion instead of just one.
Click to expand...

It depends what you want to do with the multiple returns. If you actually
want to see them individually, you could look here in the paragraph
"Arbitrary Lookups":
http://www.cpearson.com/excel/lookups.htm
But you might be better off sorting your data rather than trying to extract
matching data.

However, if you want (for example) to sum the matching returns, you can use
SUMPRODUCT, which can take as many criteria as you wish, like this:
=SUMPRODUCT( (A1:A1000=criterion1) * (B1:B1000>criterion2) * (C1:C1000))
 
Back
Top