| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with a long list
Let's say your header in row 1
and names in A2:A2000 create a dummy column In B2 =COUNTIF($A$2:A2,A2)=1 Copy down as far as needed In the menu DataFilterAutoFilterfilter all the FALSEmenu Edit Delete "deblars" wrote: I have a long list that I'd liked filter down, but don't know how. I know how to use the basic filter funtion, but I have a list with about 2000 names and I'd like to delete the duplicates within the rows. Can anyone help? -- Deb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filter and a list | New Users to Excel | |||
| Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
| Very basic question - how long can a list be? | Excel Discussion (Misc queries) | |||
| why won't vlookup work in a long list | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
Hybrid Mode
