Differences

This shows you the differences between two versions of the page.

--- excel [2019/08/20 09:26]
zeppo
+++ excel [2019/10/10 10:06] (current)
zeppo
@@ Line 1: / Line 1: @@
-**Search cells for specific text in cells and note it**
+ ====== Search cells for specific text in cells and note it  ======
   * =ISNUMBER(SEARCH("apple",A1))
@@ Line 65: / Line 65: @@
 https://www.techonthenet.com/excel/questions/remove_scientific.php
+====== REMOVE DUPLICATES FROM A COLUMN IN EXCEL ======
+REMOVE DUPLICATES FROM A COLUMN IN EXCEL
+Select the range of cells that has duplicate values you want to remove.
+Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
+Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.

ZeppoManx Wiki