About MS Excel

How to find duplicates in excel 2007? Video

2010-01-15T16:26:00.001+05:30

How to eliminate duplicates from a list in excel?

2010-01-15T16:04:00.000+05:30

Here is a step by step pictorial presentation of how to find and eliminate duplicate values from a column in a spreadsheet. Before we go for that I tell you logic behind that. We will sort the list in which we have to find duplicates. Due to sorting the list, duplicate entries will appear together. Now we will compare each cell in the list against it's previous cell. ie A2 against A1, then A3 against A2 and so on. If the value of a cell matches the value in previous cell, then it will be declared as a duplicate cell.

1. Here is a list that contains some duplicate and non-duplicate values.

2. Keep first row for header and give some meaningful header as shown in fig.

3. Then sort the list by selecting the list and clicking 'sort ascending' button.

4. After the list is sorted apply this formula in cell B2.
Formula: =IF(A2=A1,"Duplicate","Nonduplicate")

5. Then copy this formula and paste it for remaining cells.

6. This is how you will get duplicate values.

7. Then select the header and apply filter on the list.

8. Then click the dropdown menu of filter to see the options. Select whichever you want and work on it.

How to Sort a Single Column in Excel?

2010-01-13T12:29:00.000+05:30

It's very easy to sort data in Excel. Follow the steps given below with pictures to sort a single column data in excel.

1. Select the column you want to sort.

2. Then click the "Sort Ascending" button on the toolbar.

3. Your data in that column will be sorted in ascending order.

Notes:
1) If you want to sort the data in descending order, please click the "Sort Descending" button on standard toolbar. If this button is not visible, then make it visible by clicking on "Add or Remove Button".

2) There are advanced options available for sorting. On main Menu, click on "Data --> Sort" to see following window of advanced sort options. The usage of advanced sort options will be illustrated in other tutorials.

Here is a youtube video.

Welcome Guest !

2010-01-05T15:05:00.000+05:30

Welcome ! If you have any question about spreadsheets or wondering how to do certain tasks in MS Excel, then you have reached a right place. This blog will help you solve your problem or answer your questions about MS Excel, that too absolutely FREE !

Simply fire your question to admin of the blog using comments window at the bottom of this post. You need NOT require any login. You can also send your question to vegapoint@gmail.com The admin will reply you with answer of your question.

You can also search this blog to find what you want.

Thanks for visiting !

--VEGA (admin)