ExcelHow

Tag: Excel Formula Examples

How to Count Comma Separated Value in One Cell in Excel

Excel Examples

September 6, 2023
How to Calculate Average among Multiple Different Worksheets in Excel

Excel Examples

September 5, 2023
How To Split Columns to Seprated Negative and Positive Values in Excel

Excel Examples

August 30, 2023
How to Display Negative Time Value in Excel

Excel Examples

August 22, 2023
How to extract text before first comma or space

Excel Examples, Excel VBA

August 7, 2023
How to Delete or Remove Year from a Date in Excel

Excel Examples

August 6, 2023
How to VLOOKUP to Return Value if Date Falls between Two dates in Excel

Excel Examples, Excel VBA

July 31, 2023
How to Extract Text between Brackets

Excel Examples, Excel VBA

July 30, 2023
How to Get the First Monday of a Given Year

Excel Examples, Excel VBA

July 29, 2023
How to Filter Out Weekends and Weekday

Excel Examples

July 19, 2023
How to Filter And Transpose Data From Horizontal To Vertical

Excel Examples

July 11, 2023
How to Count the Number of “Yes” / “No” in a Range

Excel Examples

July 10, 2023
How to Sort Positive Numbers and Negative Numbers by Absolute Values

Excel Examples

July 9, 2023
How to Sort Data by Last Character in Excel

Excel Examples, Excel VBA

July 3, 2023
How to Remove Prefix and Suffix in Given Cells in Excel

Excel Examples

June 28, 2023
Removing Salutation from Name

Excel Examples, Excel VBA

June 11, 2023
How to Countif across Multiple Worksheets

Excel Examples

May 25, 2023
How to Split Cells by the First Space in Texts in Excel

Excel Examples, Excel VBA

May 4, 2023
How to Filter Cells Starts with Number or Letter in Excel

Excel Examples

May 4, 2023
How to Calculate Average by Month

Excel Examples

April 26, 2023