Excel IF

How to Extract Initials From a Name in Excel

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 »

How to Compare Two Columns for Differences in Excel

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 »

How to Remove Last or Trailing Commas in Excel

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 »

How to Move Every Other Row to a New Column in Excel

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 »

How to Lookup Values from Right to Left in Excel

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 »

How to Compare Two Lists in Different Worksheets using VLOOKUP in Excel

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 »

How to Extract a Unique List based on Criteria in Excel

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 »

How to Sum Range Ignoring Errors in Excel

This post will guide you how to sum range of cells ignoring Errors in Excel. How do I sum and ignore errors with a formula in Excel. How to sum range ignoring all error values with VBA macro in Excel. Sum Range Ignoring Errors with Formula Sum Range Ignoring Errors with VBA Sum Range Ignoring… read more »

Sidebar