is there a way you can filter the sheet so that it can find duplicate data and delete on demand.
2007-08-03 05:08:23 · 5 answers · asked by Anonymous in Computers & Internet ➔ Software
Yes.
Select the area
Data
Advanced filter
Unique records only
When you select unique records only, it will exclude all the duplicates. So copy the filtered records and paste somewhere else.
If you find this unsuccessful, send me a mail. There is another way to do that.
2007-08-03 08:21:43 · answer #1 · answered by voyager 6 · 0⤊ 0⤋
Can you be more specific? Duplicate Column values across rows or Duplicate Rows (Series of columns with same value).
2007-08-03 12:36:01 · answer #2 · answered by deeps 2 · 0⤊ 0⤋
Yes, But you would first have to set up a "Macro" then you would have to activate it whenever you need it to perform the fuctions you set it up to perform. You can get more information about setting up "macros" from Excel by going to the help tab. It's a bit tricky, but once you figure it out, you can adapt the macros to many other functions.
2007-08-03 12:18:20 · answer #3 · answered by fyrecrowe 3 · 0⤊ 0⤋
Highlight and click delete!
2007-08-03 12:11:16 · answer #4 · answered by Sami V 7 · 0⤊ 1⤋
BACKSPACE THX 4 THE POINTS
2007-08-03 12:15:16 · answer #5 · answered by lex8oya 3 · 0⤊ 1⤋