Codes in capitals only
PremiumProduct codes must be typed in capital letters. Write the rule for A2 in C2. Compare A2 with UPPER(A2) using EXACT, since a plain = ignores case.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product code | Product | Rule | |||
| 2 | KB-104 | Keyboard | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock Drop-down lists and data validation and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:COUNTIFSUMIF
Need help?
Why this works
UPPER(A2) is KB-104, the same as A2, so EXACT gives TRUE. Type kb-104, and UPPER makes it KB-104, which EXACT sees as different. The rule is FALSE, and Excel refuses the code.
A plain = can't do this job, because Excel ignores case in comparisons. "kb-104"="KB-104" is TRUE.
Common mistake: Writing =A2=UPPER(A2). It looks right, but = ignores case, so lowercase codes get through.
The answer
- C2
=EXACT(A2,UPPER(A2))