G
Guest
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"?
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"?