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

"Prem Soni" wrote:

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 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

"Mike H" wrote:

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

"Prem Soni" wrote:

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,

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

"Prem Soni" wrote:

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

"Mike H" wrote:

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

"Prem Soni" wrote:

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

It depends whether the content of your cells is text, or numbers in Excel
date format.
If the former, you'd be better chaging it to the latter, then the sort will
be easy.
--
David Biddulph

Prem Soni wrote:
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

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.

Prem Soni wrote:

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

--

Dave Peterson