Friday, May 31, 2013

To check for a duplicate entry in a column in excel

Take the Column in column A in which the duplicate value needs to be checked.
Use the Below formula in a new column say column B next to the A and insert the formula against it.

The status FALSE means that it is not an duplicate entry

The status TRUE means it is an duplicate entry

Thursday, May 16, 2013

Change the Password for the user in IBM MQ

Below is the command to change the Password for  a user in IBM MQ

The below needs to be given in thecommand prompt

AMQMSRVN -user <domain\>NEW_NAME -password <password>