Hi, has anyone got this issue as below,

Database:A1:D4
Industry Class| Long Term| Short Term| Weighting|
Bank | AA | A1+ | 3.00% |
Energy | A | A1 | 2.00% |
ASB | AAA | A1+ | 1.00% |

Criteria:F1:I2
Industry Class|Long Term|Short Term|Weighting|


=DMAX(Database,"weighting",Criteria)

A 3.00% (should be 2% !)
AA 3.00%
AAA 1.00%

It seems that DMAX couldn't recognise between "A" and "AA". Is this a bug in Excel?
Really need help for this one!