Forum Discussion
Sorting
I want to sort a list using day of birth, it is all the same month but different years. How do I go about it?
Let's say the birth dates are in D2:D100.
Insert a column to the right of column D. Enter the following formula in E2, then fill down:
=TEXT(D2, "mmdd")
Sort the entire range on column E.
Let's say the birth dates are in D2:D100.
Insert a column to the right of column D. Enter the following formula in E2, then fill down:
=TEXT(D2, "mmdd")
Sort the entire range on column E.
- Great! Thanks.
