How To Find Cells With Duplicate Values In Microsoft Excel

Did you know you can find cells that are duplicated between two columns in Excel? Here’s how to find cells with duplicate values in Microsoft Excel… The following code will find duplicates of the cell A1 in column B (ranged 1-250, extend the range if required) and list the contents: =IF(ISERROR(MATCH(A1,$B$1:$B$250,0)),””,A1) To use this, insert the […]
Continue reading…

 

Macros May Contain Viruses. It Is Usually Safe To Disable Macros

When opening a Word or Excel file, you may get the following security warning: Security Warning Filename.doc | xls contains macros. Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality. To fix this, you must first understand what a macro is. A […]
Continue reading…