Learn Microsoft Excel Online FreeThis 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 »
This post will guide you how to separate negative numbers and positive numbers from a column into two columns with a formula in Excel. How do I split numbers into two columns with negative and positive numbers in Excel. Splitting Columns to Separated Positive and Negative Numbers Assuming that you have a list of data… read more »
This post will guide you how to get initials from a given name using a formula in Excel. How do I extract initials from names in Excel 2013/2016. Extract Initials from a Name Using a Formula Extract Initials from a Name Using User Defined Function Assuming that you have a list of data in range… read more »
This post will guide you how to compare two columns and return differences in Excel. How do I compare two columns to find differences in Excel 2013/2016. Compare Two Columns for Differences Assuming that you have a list of data in range A1:B5, and you want to compare Column A and Column B and return… read more »
This post will guide you how to remove trailing commas from cell in Excel. How do I remove comma character at the end of a cell with a formula in Excel 2013/2016. Remove Trailing Commas if you want to remove trailing commas from you Excel cells, and you can create a formula to check for… read more »
This post will guide you how to find the first value greater than a specified value in a range of cells in Excel. How do I find the last value greater that a given value in a row with a formula in Excel. Find the Last Value Greater Than X Find the First Value Greater… read more »
This post will guide you how to move every other row to a new column in Excel. How do I move every odd row to another column with formula in Excel 2013/2016. How to move every even row to other column in Excel with VBA Macro in Excel. Move Every Other Row to New Column… read more »
This post will guide you how to vlookup values from right to left in your worksheet in excel. How do I look up values to left column with a column in Excel 2013/2016. How to use Vlookup function to extract the corresponding value of the left column in your worksheet in Excel. Lookup Values to… read more »
This post will guide you how to compare two lists in different worksheets in Excel. How do I compare two lists in different worksheets with VLOOKUP function in Excel 2013/2016. Comparing Two Lists in Different Worksheets Assuming that you have two lists of data in the different worksheets, and you want to compare those two… read more »
This post will guide you how to extract unique values in a range based on one criteria with a formula in Excel. How do I create a unique distinct list based on one condition in Excel. Extract Unique List of Values based on Criteria Assuming that you have a list of data in range A1:C6,… read more »
