ExcelBanter - DMAX criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - DMAX criteria (https://www.excelbanter.com/excel-worksheet-functions/39363-dmax-criteria.html)

joeeng

DMAX criteria

I am using DMAX($C$4:$J$498,"column heading",I4:I5) where I5 contains =C5
where C5 contains "Asset 1". Unfortunately, DMAX is not only matching "Asset
1", but also matching "Asset 10", "Asset 11", etc. What do I use in I5 to
tell DMAX to only include the exact matches for C5 contents "Asset 1"?

Debra Dalgleish

In cell I5, change the formula to: ="="&C5

joeeng wrote:
I am using DMAX($C$4:$J$498,"column heading",I4:I5) where I5 contains =C5
where C5 contains "Asset 1". Unfortunately, DMAX is not only matching "Asset
1", but also matching "Asset 10", "Asset 11", etc. What do I use in I5 to
tell DMAX to only include the exact matches for C5 contents "Asset 1"?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

joeeng

Thanks, I kept missing that & sign.

"Debra Dalgleish" wrote:

In cell I5, change the formula to: ="="&C5

joeeng wrote:
I am using DMAX($C$4:$J$498,"column heading",I4:I5) where I5 contains =C5
where C5 contains "Asset 1". Unfortunately, DMAX is not only matching "Asset
1", but also matching "Asset 10", "Asset 11", etc. What do I use in I5 to
tell DMAX to only include the exact matches for C5 contents "Asset 1"?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 10:18 PM.