In this tutorial, I will show you the step-by-step process to highlight a cell if the a value exists in another column in the worksheet in Excel.| Spreadsheet Planet
Sometimes when you receive a dataset with duplicates you may need to group the duplicates so you can easily identify them and decide to remove or consolidate| Spreadsheet Planet
Learn three easy ways to get unique values from a column in Excel: Remove Duplicates tool, Advanced Filter, and UNIQUE function.| Spreadsheet Planet
In this tutorial, I will show you two ways to find merged cells in Excel (using Find and Replace and VBA). Once found, you can unmerge these or highlight these| Spreadsheet Planet
Learn three easy ways to fill blank cells with the value above in Excel (using 'Go To Special' with a formula, 'Find and Replace' with formula, or VBA)| Spreadsheet Planet
Filling colors in cells in Excel could be quite useful.| Spreadsheet Planet
Learn how to use conditional formatting with OR criteria in Excel to highlight data that meets at least one condition.| Spreadsheet Planet
Learn 5 methods to count unique values in Excel using formulas. Find out how to exclude empty cells and improve performance for large datasets.| Spreadsheet Planet
Learn how to remove formulas but keep the data in Excel using a simple shortcut, the paste special technique or a simple VBA code.| Spreadsheet Planet
Learn how to remove duplicate rows based on one column in Excel using three easy methods: 'Remove Duplicates' feature, VBA code, and filters with the COUNTIF function.| Spreadsheet Planet
Learn how to generate unique random numbers in Excel without duplicates using the RANDBETWEEN, RAND, RANK, LARGE, and MATCH functions.| Spreadsheet Planet
Learn how to use Excel If Statement with Multiple Conditions Range, including AND and OR functions, Nested If, and other Excel functions.| Spreadsheet Planet
Learn how to compare two columns in Excel using VLOOKUP. Find matches and differences in data, and highlight rows with matching or different values.| Spreadsheet Planet