Learn Microsoft Excel Online Free
This post will guide you how to align duplicate values within two columns based on the first column in your worksheet in Excel. How do I use an formula to align two columns duplicate values in Excel. Aligning Duplicate Values in Two Columns Assuming that you have two columns including product names in your worksheet…. read more »
This post will guide you how to select all Cell values from every nth column in your worksheet in Excel. How do I select all cells in every nth column using a VBA Macro in Excel. How do I retrive or copy cell values from every nth column using a formula in Excel 2013/2016. Select… read more »
This post will guide you how to insert the contents of a paricular into the header or footer cell in your active worksheet in Excel. How do I put a cell value into header or footer in all worksheets in your active workbook using VBA Macro in Excel. Insert cell Content into Header or Footer… read more »
We may receive Excel document from partners or clients with contents marked with different formats. And you want to just clear all of these formats and make the contents in cells displayed in initial formatting by default. You can follow this article to get some methods like Clear Formats and Format Painter functions to clear… read more »
We may need to search a value among all sheets or some specific sheets in Excel workbook, and this article will introduce one method for searching a value from all or some sheets. You can use FIND function to do searching.How do I search a value from multiple worksheets in your active workbook in Excel… read more »
This article will introduce two ways to change test case in Excel. You can perform UPPER\LOWER\PROPER functions to convert text into uppercase or lowercase letters in Excel , and you can also use VBA macro to perform the task. Select one you like, and let me show you the methods. You may meet the situation… read more »
If you want to split a number with more than one digits into each individual digit in each column, what you can do? I think you can use the combination of MID and COLUMN functions to resolve your issue. Please see the method below in this article. Let’s study the two functions first. #1 MID… read more »
If you have a lists of dates like MM/DD/YYYY or other formats you like in Microsoft Excel, and you may want to filter them by month ignoring the year, you can have below two ways to do filter. Select one you like or depends the amount of date list, let’s get started. First we will… read more »
In general life we usually need to count the number among a range of values based on the criteria ‘greater than a fixed value and less than another value’. We may also need to sum the total values for the matched samples. In this case. we will use COUNTIF and SUMIF function to do the… read more »
This post will guide you how to concatenate cells if same value in another column using an VBA macro in Excel. How do I merge cells if same value exists in another column using formula and filter feature in Excel 2013/2016. Assuming that you have a list of data in range A1:B6, you wish to… read more »
