| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
microsoft excel
hi i have 200 tracking numbers a lot of them are repetitive how to i filter
them out |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
microsoft excel
Debra Dalgleish explains how he
http://www.contextures.com/xladvfilter01.html Scroll down to Filter Unique Records. Hope this helps. Pete On Mar 19, 4:50*pm, david h <david wrote: hi i have 200 tracking numbers a lot of them are repetitive how to i filter them out |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
microsoft excel
In B2: =COUNTIF(A$2:A2,A2)1
copy down Auto Filter all the TRUE values "david h" wrote: hi i have 200 tracking numbers a lot of them are repetitive how to i filter them out |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
| Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
| Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
| Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
| How do I import Microsoft Word files into Microsoft Excel? | New Users to Excel | |||
Linear Mode
