Hi Guys,
I have this sheet in which I want these three columns:
C, F, M
to be formatted as dates in UK format dd/mm/yyyy
I also want the rows to be sorted in reverse chronological order (newest first) according to the dates in column M. I want this to be permanent not just a filter sort. I am having a world of problems with this, could anyone help? Thanks
I attach the sheet. Thanks
its probably too late once you have imported into excel like that
11/20/2023
03/04/2019
11/20/2018
the red one excel has recognised as a date and thinks its 3 april when probably it was 4th march but its hard to tell without seeing the original
how are you getting the data?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks