| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding replicate data in a column accidentally entered
Hi,
I have entered data into a column. there is over 1,000 entries but I have mistakenly entered repeat data without knowing and I now need to filter out the replicate data without sifting through it manually- is there a way?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding replicate data in a column accidentally entered
=COUNTIF($A$2:A2,A2)1
copy down as far as needed Auto Filter all the TRUE value, go to Edit Delete "Fran" wrote: Hi, I have entered data into a column. there is over 1,000 entries but I have mistakenly entered repeat data without knowing and I now need to filter out the replicate data without sifting through it manually- is there a way?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding replicate data accidentally entered into a worksheet | Excel Discussion (Misc queries) | |||
| Prevent duplicate data from being entered into the same column | Excel Worksheet Functions | |||
| Colouring a row depending on data entered in a column | Excel Worksheet Functions | |||
| How do I change data that has been entered in a column to a row? | Excel Discussion (Misc queries) | |||
| Data in column predetermined by what has been entered in previous | Excel Discussion (Misc queries) | |||
Hybrid Mode
