Excel Formulas

Dynamic Range with Multiple Columns Using OFFSET in Excel

In this lesson, I'll demonstrate 3 effective examples of Creating a Dynamic Range with Multiple Columns Using OFFSET in Excel. These examples will ...

4 Ways to Convert Number to Text and Keep Trailing Zeros in Excel

When we convert numbers to text in Excel, Excel automatically removes the trailing zeros after the decimal point of a number. There are various ways ...

4 Ways to Show Formula as Text in Another Cell in Excel

It is important to show formulas in lieu of values in Excel for myriad operations or while debugging. In this article, we will learn how to show ...

3 Ways to Check If Range of Cells Contains Specific Text in Excel

Sometimes we need to search if a range of cells contains specific text in Excel. In this article, we are going to show you how to search if a range ...

13 Ways to Search for Text in Range in Excel

In the corporate world, we need to deal with a lot of data every day. We also work with data for the betterment. But the fact is we don’t need the ...

3 Ways to Count Duplicate Values in Excel Only Once

Often in a dataset, we want to estimate duplicate values once to actually determine the different entries and their number. In a large dataset, ...

5 Quick Ways to Lookup Partial Text Match in Excel (5 Quick Methods)

In Excel, we can look up values by using different functions and logical comparisons. But most of the time these functions require an exact match and ...

8 Ways to Arrange Numbers in Ascending Order in Excel Using Formula

We can use Microsoft Excel for arranging numbers in ascending or descending order by using SORT from the toolbar or just creating a table and then ...

6 Easy Methods to Compare Two Strings in Excel for Similarity

Users frequently need to compare the two strings in Excel for similarity. It's quite straightforward and easy to compare two strings. You may simply ...

9 Unique Cases to Compare Rows for Duplicates in Excel

Users frequently need to locate or compare different rows to search for all the duplicates within them in Excel. It's quite straightforward and easy ...

5 Ways to Use Formula to Find Next Month in Excel

In this lesson, I'll demonstrate 5 effective approaches to how to use Excel formulas for calculating next month including some other problems related ...

3 Easy Ways to Use INDEX-MATCH Across Multiple Sheets

Organizing data using various techniques is quite common in Excel. Records are arranged in a tabular form here. You can use different worksheets for ...

ExcelDen
Logo