Group people based on the month in Excel 2016 & 2013

This tutorial explains the procedure for grouping people based on month from the given date field in Excel 2013. Let us take the following sample data with students name and their date of birth.

image

Now to find out the list of students celebrating the birthdate grouped by months you can do the following

Step 1: Add another column next to the date column.

Step 2: For the first student, enter the formula for the new column as =MONTH(B4), where B4 is the date birth for the first student.

image

Step 3: Now use the Excel auto fill feature to copy the formulas for the other students to find out month from their date of birth.

image

Step 4: Select all the three columns, navigate to Editing section on Home menu and click Sort & Filter option and select Custom Sort from the menu list.

image

image

Step 5: In the Sort window, choose Column C for Sort by drop down, Values for Sort On drop down and Smallest to Largest for the Order. Now click Ok button to group the students based on the month of their birthdate.

imageimage

You can further simplify this by using excel filters to pick only specified month using the filter criteria on the month column.

imageimage

In Category: Excel 2013, Excel 2016, MS Office, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.