by Ilker | Jan 24, 2019 | Excel Tips & Tricks
Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods.Compare two columns...
by Ilker | Oct 10, 2018 | Excel Macros, Excel Tips & Tricks
Comparing data row by row manually can be a tedious process if done manually. Let us show you how to compare two rows in Excel using VBA and automate this process. How to compare two rows in Excel using VBA VBA has a built in function called StrComp that can...
by Ilker | Oct 10, 2018 | Excel Macros, Excel Tips & Tricks
Comparing columns of data manually is not a realistic approach when working with large data sets. Let us show you how to compare two columns in Excel using VBA and automate this process. How to Compare two Columns in Excel VBA has a built in function called ...
by Ilker | Oct 9, 2018 | Excel Macros, Excel Tips & Tricks
Excel doesn't do as good of a job as some text editors when it comes to spellchecking, and we know how frustrating this can be. Let us show you how to highlight misspelled cells in Excel using VBA. Spelling check feature has been a staple in Microsoft Office products...
by Ilker | Oct 9, 2018 | Excel Macros, Excel Tips & Tricks
Finding cells with errors can be tricky, especially in large workbooks. In this article we’re going to show you how to display cell formulas in Excel that contain errors using VBA. How to display cell formulas in Excel that have errors VBA has predefined types...
by Ilker | Jul 27, 2018 | Excel Tips & Tricks
It’s often a good idea to highlight empty cells in a data set to help easily identify the outliers. Here, you can find out how to highlight empty cells dynamically using Conditional Formatting. Steps Begin by selecting the data range B3:H10 Open the Conditional...
by Ilker | Jul 12, 2018 | Excel Tips & Tricks
It’s often a good idea to highlight the duplicate values in a data set to help easily identify the outliers. Let us show you how to highlight values based on item lists using Conditional Formatting. Syntax =COUNTIF( absolute reference of list of values, relative...
by Ilker | Jul 10, 2018 | Excel Tips & Tricks
It is often a good idea to highlight duplicate values in a data set to help easily identify the outliers. In this article we are going to explain how to find quartiles in Excel and highlight them dynamically with Conditional Formatting. Syntax = relative reference of...
by Ilker | May 31, 2018 | Excel Tips & Tricks
Highlighting cells is a good way to visualize content to locate areas that needs attention. Excel’s Conditional Formatting feature is a great tool for this job. How to highlight cells by values article will show how you can create highlight cells based on...