Excel Find Archives

FIND and SEARCH Function in Excel (2 Comparison Studies)

May 17, 2023

It is a very common occurrence to find the position of a particular character or text within a string. This is helpful for data analysis purposes ...

FIND and SEARCH Function in Excel (2 Comparison Studies)

How to Find External Links in Conditional Formatting in Excel (2 Ways)

Feb 27, 2023

Assume your worksheet contains a large number of external links, and you now have to dynamically identify the cells that contain the links and ...

How to Find External Links in Conditional Formatting in Excel (2 Ways)

How to Find Max Value in Range with Excel Formula (5 Easy Methods)

Feb 9, 2023

Sometimes we need to find the max value in a range using an excel formula. Luckily Microsoft Excel has several functions which we can use to ...

How to Find Max Value in Range with Excel Formula (5 Easy Methods)

How to Find Excel Sheet Name Using Formula (3 Examples)

Feb 12, 2023

In a Microsoft Excel file usually, we get the sheet name from the bottom of each sheet. But there are other options to find sheet names. We will ...

How to Find Excel Sheet Name Using Formula (3 Examples)

FIND Function Not Working in Excel (4 Reasons with Solutions)

Feb 12, 2023

In this tutorial, we will explain the reasons for the problem of why the FIND function in excel is not working. In Microsoft Excel, the FIND function ...

FIND Function Not Working in Excel (4 Reasons with Solutions)

How to Use Formula to Find Bold Text in Excel

Feb 12, 2023

Excel users often find themselves finding specific format entries. Formula to find bold text in Excel is one such incident. Among hundreds of ...

How to Use Formula to Find Bold Text in Excel

How to Find Last Non Blank Cell in Row in Excel (5 Methods)

Feb 9, 2023 4

It is not a matter of astonishment that we might face the requirement to find last non blank cell in row in Excel. Here, we will try to sort out some ...

How to Find Last Non Blank Cell in Row in Excel (5 Methods)

[Solved!] CTRL+F Not Working in Excel (5 Fixes)

Feb 12, 2023

To find values, we frequently use the Find and Replace tool by using the shortcut CTRL+F. But you might face some unexpected problems while using the ...

[Solved!] CTRL+F Not Working in Excel (5 Fixes)

[Fixed]: Can’t Find Project or Library Error in Excel (3 Solutions)

Feb 14, 2023

While working with a large Microsoft Excel dataset, sometimes we see that our VBA macros show an error named “can’t find project or library”. It ...

[Fixed]: Can’t Find Project or Library Error in Excel (3 Solutions)

How to Find Character in String from Right in Excel (4 Easy Methods)

Feb 9, 2023

The article will describe the procedure to find character(s) in a string from right in Excel. Sometimes we need to store the last data of a character ...

How to Find Character in String from Right in Excel (4 Easy Methods)

How to Find * Character Not as Wildcard in Excel (2 Methods)

Feb 9, 2023

The wildcard is a special character that helps us to match texts in Excel. This is a very handy tool. Excel has three characters as wildcards to use ...

How to Find * Character Not as Wildcard in Excel (2 Methods)

How to Find Last Row with a Specific Value in Excel (6 Methods)

Feb 15, 2023

Here, we have a sample dataset containing Customer Name, Gender, Loan Purpose, Job, and Credit Risk. As we can see, there is repetition in the ...

How to Find Last Row with a Specific Value in Excel (6 Methods)

Excel Find Last Occurrence of Character in String (6 Methods)

Feb 15, 2023 2

In this article, we’re going to find the last occurrence of a character in a string in Excel. Our sample dataset has three columns: Company Name, ...

Excel Find Last Occurrence of Character in String (6 Methods)

How to Find First Value Greater Than in Excel (4 Ways)

Feb 16, 2023

In this article, we will learn about Excel Find First Value Greater Than any specified Value using a few easy formulas. Suppose we have a dataset ...

How to Find First Value Greater Than in Excel (4 Ways)

How to Use Excel Formula to Find Last Row Number with Data (2 Ways)

Feb 15, 2023

In this tutorial, we will demonstrate how to use an excel formula to find the last row number with data. While working in Microsoft Excel we might ...