# Tag: Logical Formulas

## Find max unique value from a range that have duplicate numbers and blanks

Problem: How to find Min and Max numeric values in a range of cells that have duplicate numbers and blanks, but only …

## Learn to Use INDEX MATCH MATCH

What INDEX MATCH MATCH offers you is a more powerful version of the formula. Instead of just a vertical lookup, INDEX MATCH …

## Learn to use HLookup in Excel

HLOOKUP is essentially the horizontal version of VLOOKUP. The primary reason for using HLOOKUP in Excel is for when you have key …

## Excel Count Functions

Excel Count Functions Examples show how to count Excel cells with numbers, text, blanks, or cells that contain specific words or other …

## Excel’s Operators CHEAT SHEET

Excel’s Operators CHEAT SHEET Believe it or not, Excel has 16 infix operators, 5 match fix operators, 3 prefix operators and a …

## How to Use VLOOKUP MATCH

VLOOKUP MATCH is one of several possible lookup formulas within Microsoft Excel. This tutorial assumes you already have a decent understanding of …

## VBA Macro to Compare Two Files to Determine if They are Identical

This function will allow you to compare one file to another. Copy code below and paste directly into your VB project. Sub …

## Essential Excel functions: Mighty IF logic

You have probably been doing “if” logic ever since you were a toddler: If this is true, then this; otherwise, this. IF …

## An alternative Excel averaging formula that doesn’t evaluate zero

Excel’s AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives. Excel’s AVERAGE() function considers zero values in …

## How to Use COUNTIFS() to Evaluate Multiple Count and Criteria Ranges

Excel’s COUNTIFS() function is flexible enough to handle different ranges and data types. In Count the number of Excel records that fall between …