Question about Microsoft Computers & Internet
One way of finding (and removing) duplicate entries is to sort the column and put a simple formulate in a temporary column next to that column; for example - if column A has duplicates, insert a column (B) and starting in B2 put if(A2=A1,"DUP",""). Select B2 and scroll down to the bottom of your spreadsheet. Press <ctrl>-D to extend the formula in B2. Wherever there is a duplicate you'll see "DUP" in column B. If you want to remove the duplicates copy column B and Edit / Paste Special... with "values" selected (to wipe out the formula). You can then sort the spreadsheet on column B and remove rows with DUP in column B.
If you can't delete the duplicate rows and the order is important first include a column that captures the order - same trick except put row() in that column, copy / paste special the values and then you can re-sort after doing the above to have both the DUPs marked and the original order.
Hope that helps.
Posted on Aug 11, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Sep 23, 2009 | Computers & Internet
Sep 18, 2009 | Microsoft Excel for PC
Jun 18, 2009 | Microsoft Excel for PC
Mar 30, 2009 | Microsoft Excel for PC
Mar 21, 2009 | Microsoft Works 8.0 for PC
Feb 17, 2009 | Microsoft Excel for PC
Sep 29, 2008 | Microsoft Computers & Internet
Apr 09, 2008 | Microsoft Excel for PC
Jan 25, 2008 | Computers & Internet
Dec 19, 2007 | Computers & Internet
Dec 28, 2017 | Microsoft Computers & Internet
151 people viewed this question
Usually answered in minutes!