Highlight Duplicate Entry in Excel

You may have to highlight duplicate entries in the excel and you may think it is very difficult to do. We have a solution for it. You need to just copy the below code and it to the excel.

In order to add the code to excel, please follow the steps given below:
1. Open the Excel file.
2. Right click on the page name.
3. Click on the 'View code' option.
4. Paste the following code and save.

Sub FindDups ()
'
' NOTE: You must select the first cell in the column and
' make sure that the column is sorted before running this macro
'
ScreenUpdating = False
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1, 0).Value
Offsetcount = 1
Do While ActiveCell <> ""
If FirstItem = SecondItem Then
ActiveCell.Offset(Offsetcount,0).Interior.Color = RGB(255,0,0)
Offsetcount = Offsetcount + 1
SecondItem = ActiveCell.Offset(Offsetcount, 0).Value
Else
ActiveCell.Offset(Offsetcount, 0).Select
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1,0).Value
Offsetcount = 1
End If
Loop
ScreenUpdating = True
End Sub.

5. Sort the column using 'Sort' option. 

6. Go to the macros and click on the 'Run' button.
7. Duplicate entry will be shown in red.

Investments in Share Market

Indian Share Market is crashing. However, you can make money by investing on the following shares. Even the SENSEX has fallen down, you can view the upward movement in this share. Those who are small investors can invest and get a huge profit.
1.

506457

GUJ.CARBON

2.

530519

INTERFACE

MySQLDumper - An Easy way to take backup of MYSQL Database

MySQLDumper is a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and - if needed - restore it. It is especially suited for shared hosting, where you don't have shell access. This application can be easily installed to your account.

In order to install this application, you need to download the application by Clicking Here. Once you have downloaded the file, please upload to your account and unzip the file to a folder. Access the folder and it will ask the database name, username, password and hostname. You need to enter the database details of the database of which you need to take the database backup. Once it is done, you can easily take backup of the database and store in your account as well as download it to your computer.