Remove duplicate values Select the range of cells, or ensure that the active cell is in a table. On the Data tab, click Remove Duplicates (in the Data Tools group). Do one or more of the following: ... Click OK, and a message will appear to indicate how many duplicate values were removed, or how many unique values remain.
Sort data using a custom list. Filter data in a range or table. Excel is an amazing tool for analyzing data. And Sort and Filter are some of the most commonly used features to help you do this. To change the order of your data, you'll want to sort it.
Sorting Dates by Month Select the cells in column B (assuming that column B contains the birthdates). Choose Cells from the Format menu. ... Make sure the Number tab is displayed. ... In the Category list, choose Custom. In the Type box, enter four lowercase Ms (mmmm) for the format. Click on OK. ... Select your entire list.
Insert a blank column next to your Date column. Assuming your first date is in cell A4, in the blank column, enter the formula: = TEXT( A4," MMDD") Copy this formula down to the bottom of your data. Sort your data on this column.
To create a custom sort: Select a cell in the column you want to sort by. ... Select the Data tab, then click the Sort command. ... The Sort dialog box will appear. ... The Custom Lists dialog box will appear. ... Type the items in the desired custom order in the List entries: box. ... Click Add to save the new sort order.
Here's how to sort unsorted dates: Drag down the column to select the dates you want to sort. Click Home tab > arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest.
Click the “ Data” tab and locate the “ Sort & Filter” section. Click the “ Filter” button. Note that each header will have a small drop down arrow to the right of the cell. Click the top of a column that you want to sort and use the appropriate “ Sort” buttons from the Sort & Filter section.
To sort a range: Select the cell range you want to sort. ... Select the Data tab on the Ribbon, then click the Sort command. ... The Sort dialog box will appear. ... Decide the sorting order (either ascending or descending). ... Once you're satisfied with your selection, click OK. ... The cell range will be sorted by the selected column.
Select the range of cells, or ensure that the active cell is in a table. On the Data tab, click Remove Duplicates (in the Data Tools group). Do one or more of the following: Under Columns, select one or more columns.