If you're writing a formula that involves comparing two strings of text, beware. Two identical strings of text, one in uppercase, the other in lowercase, will be considered to be the same. Use the EXACT function if you want to differentiate between the two.
Wizard’s tips by email
Search this site
TagsACOS ADDRESS Chart COLUMN CONCATENATE Conditional format COS COUNTA COUNTIF Custom View Dates Dropdown Format Formulae Frequency IF INDIRECT LARGE MAX MID MOD Named ranges Navigation OFFSET Paste Special Percentages PivotTable PivotTables PRODUCT RADIANS RAND RANK Reference Ribbons ROUND ROUNDDOWN Shortcut Sorting Sudoku SUM SUMIF Syntax Text to columns Trigonometry VLOOKUP