Virtually Anything

Business Tips

Posted by collinsadmin on August 22, 2008

Welcome to the newest category of my blog, business tips.  This category is where I will post a weekly tip about anything from general business tips to tips on different software that is used.

For the first tip, I would like to show you how to search for duplicates in excel when you are unable to sort your document.

Open your document:

Highlight the column that you want to use to test for duplicates

Click on Formats

Click on Conditional Format

Where it says “Cell value is” Change to “Formula is”

(Assuming you are using column A) In the box to the right, type in the following formula:

 =COUNTIF(A:A, A2)>1

Click on the button that says Format

Another box opens that says Format cells.

Click on the patterns tab

Select the color you wish for the duplicates to appear in, click ok

Then on the conditional formatting box, click Ok.

Scroll down and you will see all instances of duplication are highlighted in the color you chose.

This tip comes in handy when you have a large spreadsheet that you know has duplicates but you do not want to spend the time going through each one manually.

Next week: Removing the conditional formatting

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: