How to Count Cells with Errors in Excel. Count Specific Error eg #N/A or Count All Errors
Microsoft Excel Tips and Tricks I demonstrate how to count the number of cells that contain an error. You can[…]
Read more
Category: Excel
Excel Find Position of a Value in a Range and Return that Value’s Cell Address
Microsoft Excel Tips and Tricks I demonstrate how to return the position of a value within a range of values[…]
Read more
Compare Values in Excel (5 Ways) – Beginner to Advanced
Microsoft Excel Tips and Tricks How to compare text, numbers, and dates in Excel – including case sensitive text comparisons[…]
Read more
Formula to Identify Outliers in Excel Data Set | Highlight Outliers
Microsoft Excel Tips I demonstrate how to identify outliers in an Excel data set. Credit Chester Tugwell
Read more
Can you Filter Horizontally in Excel? | Can You Filter Rows Instead of Columns in Excel? | 3 Methods
Microsoft Excel Tips Are you able to filter horizontally in Excel? The answer to this question is: not really! However,[…]
Read more