Link to home
Create AccountLog in
Avatar of shilpi2
shilpi2

asked on

sort date

Hi Experts,

I want to sort a column of dates in descending order. However, I am unable to do so. PFA the excel sheet.

Thanks

Shilpi
Book1.xls
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of shilpi2
shilpi2

ASKER

I tried. Still does not sort.:-(
Book1.xls
Your first sort field needs to be Column C.

I just did this:

1) Selected the populated range in B:C

2) Did a sort based on Col C, descending, no header row

It sorted exactly as expected.