mandyweems
New Member
- Joined
- Jan 26, 2005
- Messages
- 3
I have a huge data base and i need to cut out all of the duplicates i have been told that it is called a "perge" but i have know idea what i am doing
PLEASE HELP
PLEASE HELP
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
[b]PLEASE HELP ME[/b]
- Thread starter mandyweems
- Start date
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
Welcome to the board.
If you're trying to de-dup column A,
1) Select column A
2) go to data --> filter --> advanced filter.
3) Select "copy to another location", enter B1 or other location for the top most entry, check the "unique records only" box, and click OK.
If you're trying to de-dup column A,
1) Select column A
2) go to data --> filter --> advanced filter.
3) Select "copy to another location", enter B1 or other location for the top most entry, check the "unique records only" box, and click OK.
Upvote
0
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Duplicate post. Please stay to one thread on the same topic:
http://www.mrexcel.com/board2/viewtopic.php?t=127293
http://www.mrexcel.com/board2/viewtopic.php?t=127293
Upvote
0
- Status
Similar threads
- Question
