Log in
x
or
x
x
Register
x

or

Excel Tips: Edit > Find

Find Blank Cells

How to find first blank cells in column in Excel?

How to find the nth non blank cell in Excel?

How to loop through rows until blank in Excel column?

Find by Formatting

How to find all underlined texts in a range or whole worksheet in Excel?

How to find cells with/having conditional formatting in Excel?

How to quickly find and filter cells by italics format in Excel?

Find by Position

How to find and get the value of first visible cell after filtering in Excel?

How to find first value not equal to a value such as 0 in Excel?

How to find first/all numbers in a string in Excel?

How to find the last row or column with data in Excel?

How to reverse search last word in a string with formula in Excel?

Find Duplicate or Unique Values

How to detect duplicate entries in a list in Excel?

How to find and count duplicate cells/values in a single row in Excel?

How to find and highlight the duplicate names which both match first name and last name in Excel?

How to find duplicate or unique values in two columns of two sheets?

How to find duplicate or unique values in two columns of two sheets?

How to find duplicate values in two columns in Excel?

How to find duplicate values without removing them in Excel?

How to find intersection of two column lists in Excel?

How to find the first duplicate value in Excel column?

How to find unique/duplicate values between two columns in excel?

How to quickly find partial duplicates in an Excel column

Find Max or Min Values

Find the lowest common denominator or greatest common factor in Excel

How to find address of cell with max or min value in Excel?

How to find and extract maximal / minimal string based on alphabetic order in Excel?

How to find the longest or shortest text string in a column?

How to find the max length in an Excel column?

Find Specific Values

How to find address of cell containing specific text in Excel?

How to find exact word in a string in Excel?

How to find out if exact match in Excel?

How to find string in a cell/column with formulas in Excel?

How to loop through rows until a specific value found in Excel?

Find or Search Scope

How to always search in whole workbook?

How to find specific value in merged cells in Excel?

How to quickly search a value in multiple sheets or workbooks?

How to search by worksheet name in Excel?

How to search value in all open Excel workbooks?

Others

How to apply fuzzy lookup to find approximate match result in Excel?

How to apply the reverse find or search function in Excel?

How to find all combinations that equal a given sum in Excel?

How to find all embedded objects in Excel?

How to find all possible sums of two numbers in a list in Excel?

How to find and break external links in Excel?

How to find and list all links (external references) in Excel?

How to find and locate circular reference in Excel quickly?

How to find broken links in Excel?

How to find cells with/having data validation in Excel?

How to find out if a cell is referenced in other cell in Excel?

How to find value in a cell with comma separated list in Excel?

How to identify and return row and column number of cell in Excel?

How to loop through files in a directory and copy data into a master sheet in Excel?

How to quickly find missing date from a list in Excel?

How to quickly find the position of first letter (alpha) from string in Excel?

How to quickly find the position of first uppercase in Excel text string?

How to search or find multiple values at once in Excel?