ExcelHow

Tag: Excel IF

How to Average Only Positive or Negative Numbers of a Range

Excel Examples

April 14, 2023
How to Count Only Unique Values Excluding Duplicates in Excel

Excel Examples

April 12, 2023
Calculate Days Open in Excel

Excel Examples

April 12, 2023
How To Align Duplicate Values within Two Columns in Excel

Excel Examples, Excel VBA

April 10, 2023
How to Count Numbers with Leading Zeros

Excel Functions, Excel VBA

April 8, 2023
Excel Array Construction

Excel Examples, Excel Glossary

April 8, 2023
Find Missing Numbers in a Sequence in Excel

Excel Examples, Excel VBA

April 4, 2023
How to Count the Average Between Two Dates in Excel

Excel Examples, Excel VBA

April 4, 2023
How to get first word from text string

Excel Examples, Excel VBA

April 3, 2023
How to Remove Last or Trailing Commas in Excel

Excel Examples

April 3, 2023
How to get nth Match with One Criteria using INDEX/MATCH

Excel Examples

March 27, 2023
How to Convert Julian Date to a Calendar date in Excel

Excel Examples

March 26, 2023
How to Find the Last or First Value in a Range Greater Than X in Excel

Excel Examples

March 22, 2023
How to Replace Duplicates with Blank Cells in Excel

Excel Examples

March 13, 2023
How to Ignore Blank Cells in a Formula in Excel

Excel Examples

March 12, 2023
Show Only Positive Values

Excel Examples

March 10, 2023
Phone Number Format in Excel

Excel Examples, Google Sheets Examples

August 2, 2022
If Cell Contain Specific Text

Excel Examples, Google Sheets Examples

July 27, 2022
Cell Contains Number

Excel Examples, Google Sheets Examples

July 19, 2022
Add Row Numbers And Skip Blanks in Excel

Excel Examples

April 3, 2022