How to generate random numbers in Excel

Here is how you can generate random numbers in Excel: Put all your possible characters into an individual cell, such as A1:

You can name this cell MySource. You could then use a formula such as the following to return the random string of characters (broken into individual lines for clarity, but it is still […]

Count Cells with Numbers

Excel Count Formula

If you need to count all cells with numbers you can use the Excel COUNT function which counts cells that contain numbers. Its syntax is: =COUNT(value1, value2,…valueX). value1, value2,…, valueX  can be cell references, or values typed into the COUNT formula. Excel COUNT function example – count numbers in cells A2:A7. In the cell where […]

Find duplicate cells values in Excel 2010 & 2013

Duplicated Values result

To quickly find duplicate values in a Excel spreadsheet you can use Conditional Formatting under Home tab. There is a special rule for this called Duplicate Values… Highlight the cells in which you want to find the duplicates and click on the Conditional Formatting | Highlight Cells Rules | Duplicate Values Select the formatting for duplicates and click OK.

Find duplicate cell values in Excel 2010

To quickly find duplicate values in a Excel spreadsheet you can use Conditional Formatting under Home tab.There is a special rule for this called Duplicate Values… Highlight the cells in which you want to find the duplicates and click on the Conditional Formatting | Highlight Cells Rules | Duplicate Values Select the formatting for duplicates […]

How to create Out Of Office reply without MS Exchange

If you don’t have an Exchange server you can create an auto-reply template: Create an auto-reply email template and save it as an Outlook template Create a message reply to send an automatic reply to your emails. In Tools | Rules and Alerts create a new rule (Start from a blank rule, click Check messages […]

Internet Explorer 9 – “Your security setting level puts your computer at risk”

Internet Explorer 9 - Your security setting level puts your computer at risk

“Your security setting level puts your computer at risk” – to disable the security settings error messages you have to disable the Turn off the Security Settings Check feature: Open Group Policy (type gpedit.msc in the Search programs and files field). Go to Computer Configuration | Administrative Templates | Windows Components | Internet Explorer   Look […]