ExcelHow

Category: Excel Examples

How to ignore Blank Cells while Concatenating cells in Excel

Excel Examples, Excel VBA

July 12, 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 Color Only Half a Cell in Excel

Excel Examples

July 9, 2023
How to Look up Value and Return Adjacent Cell Value in Excel

Excel Examples

July 9, 2023
How to Round the Calculated Average result in Excel

Excel Examples

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

Excel Examples, Excel VBA

July 3, 2023
How to Round Off Date to the Nearest Month in Excel

Excel Examples

July 2, 2023
How to Format cells containing #N/A Error in Excel

Excel Examples

July 2, 2023
How to Calculate Percent Change between Two Numbers in Excel

Excel Examples

July 1, 2023
How to Count the Number of Cells with non-zero value in Excel

Excel Examples

June 29, 2023
COUNTIF Function: Everything You Need To Know

Excel Examples

June 28, 2023
How to Remove Prefix and Suffix in Given Cells in Excel

Excel Examples

June 28, 2023
How to Sum Only Numbers in Bold in a Range of Cells in Excel

Excel Examples, Excel VBA

June 27, 2023
How to Select Entire Column except Header Row in Excel

Excel Examples

June 26, 2023
How to Find the First or Last Positive or Negative Number in a Column/List in Excel

Excel Examples

June 25, 2023
How to Delete Blank Rows in Excel

Excel Basics, Excel Examples

June 17, 2023
Removing Salutation from Name

Excel Examples, Excel VBA

June 11, 2023
How to Extract Initials From a Name in Excel

Excel Examples, Excel VBA

June 4, 2023