# Tag: Logical Formulas

## Excel Tip : How to Generate Unique Usernames using the IF() and COUNTIF() Functions

Today let’s learn how to generate unique usernames in Excel, even when you have duplicates in your data. Formulas Used 1) IF( …

## How to Flag Multiple Matches In Your VLOOKUP Formula?

This article will explore the Excel VLOOKUP Formula and show you how to combine it with an IF statement to flag if …

## Excel Formula : SUMPRODUCT () for Advanced Users

When I first learned about the SUMPRODUCT  formula  in  Excel , I almost dismissed it as a useless  formula  used by only few …

## How to Define a Named Range in Excel? What are the top 3 uses of Named Ranges?

Another underused feature of Excel is Named Ranges. Named Ranges allow you to assign a meaningful name to a cell or a …

## How to select cells that only contain Text, Number or Error in Microsoft Excel

At times you may want to select the cells that have specified type of data in it, by which you can distinguish …

## How to Highlight a Row in Excel Using Conditional Formatting

You can use conditional formatting to format or color the cells based on their contents. For example, you have a cell to …

## How to extract initials from names in Excel?

Here I introduce few tricks to quickly extract initials from the name list in Excel, like TCS for Tata Consultancy Service and …

## How to get the Last Numeric Value in a Column?

Returning the final value in a column is particularly useful for spreadsheets that involve running balances, where you want to reference the …

## How to use SUMIFS with multiple criteria in same column in Excel

SUMIFS() lets you sum values by multiple conditions in multiple columns. But how about applying multiple conditions on single column? For example …

## How to VLOOKUP with Multiple Criteria in Multiple Column

VLOOKUP is definetly a great tool to get the data from tables, however it has limitations: it can only work with one …