How-To Geek on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn ...
How-To Geek on MSN

The 4 Excel find and replace tricks I use to save hours

Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...