User Tools

Site Tools


excel

Differences

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

Link to this comparison view

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.
  
  
  
excel.txt ยท Last modified: 2019/10/10 10:06 by zeppo