Skip to main content

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?