DOB short in acceding order

  • Thread starter Thread starter Prem Soni
  • Start date Start date
P

Prem Soni

Hi,

I have a excel sheet of my company employees details with their date of
birth (i.e. 20-Mar-71) detail.
now i want to short all rows by employee date of birth in acceding order.
like this:
18-Jul-1982
01-Aug-1985
08-Sep-1991
22-Nov-1986

Kindly suggest me on this.....

Thanks....
PREM SONI
 
Hi,

At the risk of pointing out the obvious why not select them and then

Data|Sort select the column and ascending and sort

Mike
 
Hi Mike,

Thanks for responding.
I have done the same but it shorting year wise i want to short in that
column in Month and then day wise. Kindly suggest me.

Thanks,
PREM SONI
 
Hi,

2 helper columns

Column b = Month(a1)
Column c =Day(a1)

Drag both columns down

Select all 3 columns then sort on Column B ascending and column C ascending

Columns B&C can be hidden

Mike
 
If I want to sort by month, then day, I'll use a helper column with a formula
like:

=text(a1,"mmdd")
(and drag down)

And then sort the entire range by this helper column.
 
Back
Top