![]() In the Type box, enter four lowercase Ms (mmmm) for the format.The Number tab of the Format Cells dialog box. Excel displays the Format Cells dialog box. Select the cells in column B (assuming that column B contains the birthdates).If this is the case, you can follow these steps to sort by month: This approach works fine, but you may not be able to add another column to your worksheet. You can now sort the list based on the contents of column C, with the result that the list is sorted by month. The result is that column C will contain numbers ranging between 1 and 12, representing to birth months of the people. This particular formula would go in cell C3, but similar formulas would go in each cell of column C. ![]() In this column you could then use the MONTH function, as follows: This column will be named something descriptive, such as "Birth Month" or simply "Month." For instance, let's say that you have people's birthdays in column B, you could add the new column in column C. The easiest way to do this is to add a new column to your table. For instance, you may have a list of people and their birthdays, and you want to sort the list by birthday month so that you know whose birthdays occur within a particular month. ![]() There may come a time when you have a need to sort a list of information based on the month represented in a particular column.
0 Comments
Leave a Reply. |