This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
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)) | * =ISNUMBER(SEARCH("apple",A1)) | ||
Line 65: | Line 65: | ||
https://www.techonthenet.com/excel/questions/remove_scientific.php | 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. | ||