strings as criteria in database function DCOUNT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem with using strings as criteria in the database function
DCOUNT. If I use a criterium such as "loc1", it counts all the locations
starting with "loc1", so also "loc10", "loc1b" "loc11". For example:
=dcount(database;criteria) return 3, where it would like it to return 1

criteria:
location name
loc1 a

database:
location name
loc1 a
loc10 a
loc10 a

I know i could prevent it by using loc01, but i would like to know if there
is a button or switch somewhere that also does the trick. And does anyone
know if this function perforedm differently in older version of excel?
(pre-2000)
 
Back
Top