How to find duplicates in Excel

To find duplicate records:

Put this at formula, and change rows number as needed. =IF(COUNTIF(C$4:C$1000,C129)>1,"Duplicated","")

Full Documentation at: http://www.techrepublic.com/blog/windows-and-office/how-to-find-duplicates-in-excel-245163/

VB6 Package and Deployment wizard compile error 80010108

This is a known issue and has been tracked. The Track ID is 53800.

To resolve this error, open Crystl32.dep in Notepad or a similar text 
editor and modify the section: 

[CRPE32.DLL]
Dest=$(WinSysPath)
Uses1=CRPE32.DLL
Uses2

Now just comments above lines as shown below in Crystl32.dep. 

;[CRPE32.DLL]
;Dest=$(WinSysPath)
;Uses1=Crpe32.dll
;Uses2= 

Also ensure that the Crystl32.dep file is in the \WinNT\System32 folder.