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 expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Aug 14, 2013 | Microsoft Office Computers & Internet
Sep 18, 2009 | Microsoft Excel for PC
Jun 18, 2009 | Microsoft Excel for PC
Mar 30, 2009 | Microsoft Excel for PC
Mar 23, 2009 | Microsoft Office Excel 2003 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
Dec 19, 2007 | Computers & Internet
148 people viewed this question
Usually answered in minutes!