| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplication
I am currently downloading stuff to an excel spreadsheet. I was wondering if
there is a formula or a macro that I can run in Excel to remove duplicated account numbers that are downloaded to the form? Can someone please advise? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplication
Assuming that your account numbers start in column a2
type this formula is column b =IF(COUNTIF($A$2:A2,A2)1,"Duplicate","Unique") Copy this formula down to your next row's to see all duplicate. You could use filter to delete the duplicates and retain only unique account numbers. hope this helps. "Welthey" wrote: I am currently downloading stuff to an excel spreadsheet. I was wondering if there is a formula or a macro that I can run in Excel to remove duplicated account numbers that are downloaded to the form? Can someone please advise? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplication
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm Welthey wrote: I am currently downloading stuff to an excel spreadsheet. I was wondering if there is a formula or a macro that I can run in Excel to remove duplicated account numbers that are downloaded to the form? Can someone please advise? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup and Reference (without duplication) | Excel Worksheet Functions | |||
| How do you compare 2 different spreadsheets for duplication? | Excel Worksheet Functions | |||
| How do I prevent duplication of numbers in a column | Excel Discussion (Misc queries) | |||
| Remove duplication from validation list? | Excel Worksheet Functions | |||
| prevent duplication | Excel Discussion (Misc queries) | |||
Linear Mode
