Excel Tip: Easy Way to Find Duplicate Items in a Column

Posted on 20. Apr, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

If you find yourself always merging worksheets of client data and know that there must be duplicates, here is an easy way to find those duplicate entries. Select the range of cells On the menu bar, click on format, conditional formatting Under Condition 1, select Formula is In the formula =Countif (column range you are [...]

Continue Reading →

MS Excel Tip: Delete Duplicate Rows from a List in Excel

Posted on 15. Jun, 2010 by in VirtualConnections Newsletter, Windows Resources/Tips

A duplicate row (also called a record) in a list is one where all values in the row are an exact maatch of all the values in another row. To delete duplicate rows, you need to filter a list for unique rows, delete the original list, and then replace it with the filtered list. The [...]

Continue Reading →