I have a column with formulas and the result of the formulas is a date (in each cell). Now I want to order that column from oldest to newest date. Ordering through the filter apparently doesn't work so I assume it is because I am using formulas.
Is there a way that I can order that column?
Last edited by pansovic; 08-26-2010 at 02:18 PM.
It is usually quite difficult to sort a data table based on formulaic data. Not impossible, just difficult, as you've already discovered.
We'd need to see the workbook to see if it's doable in any simple way.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the help. Meanwhile I had made some changings and noticed that now it does work. I have no idea why but at least it works. Thanks again for your consideration.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks