ExcelHow

Tag: Excel IF

How to Hide Zero (0) Values in Excel

Excel Examples

July 3, 2024
How to Change Negative Number to Zero in Excel

Excel Examples

June 26, 2024
Fix #N/A Error For VLOOKUP From Another Sheet

Excel Examples

June 21, 2024
How to Find Duplicate Values in Two Columns

Excel Basics, Excel Examples

June 20, 2024
How to Ignore Blank or Zero Cells with Conditional formatting

Excel Examples

June 4, 2024
How to Compare Two Lists in Different Worksheets using VLOOKUP in Excel

Excel Examples

June 4, 2024
How to Create Dynamical Drop-Down List and Sort by Alphabetical Order in Excel

Excel Examples

May 31, 2024
How to Count Duplicates

Excel Examples

May 16, 2024
How to Find Max And Min Value with Single or Multiple Criteria in Excel

Excel Examples

May 1, 2024
If Cell Contains Certain Text OR Equals Certain Text

Excel Examples

April 16, 2024
How to Compare Two Columns and Remove the Duplicate Values by Formula in Excel

Excel Examples

April 3, 2024
How to Count Unique Values Using Pivot Table

Excel Examples, Excel Pivot Table

March 26, 2024
How to Calculate the Median in Different Cases in Excel

Excel Examples

March 25, 2024
How to find nth Occurrence with Multiple Criteria Using INDEX/MATCH

Excel Examples

March 24, 2024
How to Sum Range Ignoring Errors in Excel

Excel Examples

February 29, 2024
How To Concatenate Cells If Same Value Exists in Another Column in Excel

Excel Examples, Excel VBA

January 24, 2024
How to Sum by Group in Excel

Excel Examples

January 21, 2024
How to Compare dates if it is greater than a given date in excel

Excel Examples

January 14, 2024
How to Display User-Defined Text in All Blank Cells in Excel

Excel Examples

January 8, 2024
Comparing Columns Using Conditional Formatting Icon Sets

Excel Examples

January 7, 2024