ExcelHow

Tag: Excel Formula Examples

How to Concatenate Data with a Line Break in Excel

Excel Examples

January 14, 2019
How to Remove Numbers from Text in Excel

Excel Examples, Excel VBA

January 14, 2019
How to Get Cell Address of Max or Min Value in a Range in Excel

Excel Examples

January 11, 2019
How to Extract a Unique Distinct List from a Column in Excel

Excel Examples

January 10, 2019
How to Compare Two Columns and Return Values in Third Column in Excel

Excel Examples

January 10, 2019
How to Round a Range of Cells in Excel

Excel Examples, Excel VBA

December 6, 2018
How to Vlookup to Return Blank Instead of 0 or NA Error in Excel

Excel Examples

November 29, 2018
How to Add the Current Month or Year in a Cell in Excel

Excel Examples

November 26, 2018
How to Find and Highlight Duplicate Rows in Excel

Excel Examples

November 20, 2018
Converting Dates to Fiscal Quarters and Years

Excel Examples

November 1, 2018
Returning Value if the Dates Fall between Two Dates

Excel Examples

October 24, 2018
Count the Number of Weekends between Two Date

Excel Examples

October 23, 2018
Count the Number of Workdays between Two Dates

Excel Examples

October 22, 2018
Calculating Discount Rate

Excel Examples

October 18, 2018
Check If Value in a Column exists in Another Column in Excel

Excel Examples

October 12, 2018
Split Dates into Separate Cells in Excel

Excel Examples

October 10, 2018
Find the Earliest and Latest Date in a Range of Dates in Excel

Excel Examples

October 10, 2018
Remove Trailing Spaces from Cells in Excel

Excel Examples, Excel VBA

October 8, 2018
Sum Only Positive Numbers or Negative Numbers in Excel

Excel Examples

October 7, 2018
Extract Month and Year from Date in Excel

Excel Examples

October 4, 2018