How do I sort a column of formulas in Excel?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Gordon (Gordon_at_discussions.microsoft.com)
Date: 11/26/04 

Date: Fri, 26 Nov 2004 07:19:04 -0800

I have a column of dates that I produced by putting in the first date. Then
the next and following were simply a formula =SUM(A4+7) and so on for five
years of Sundays. I wanted to have two for each sunday I could have them
sorted by AM or PM so I duplicated the list and put AM in the next column
beside the first 5 years of Sundays and PM beside the next five years.
I then sorted with column A (dates) descending and column B (AM/PM)
descending.
I expected to get 01/01/2000 AM and then 01/01/2000 PM under each other and
so on but the formulated column would not sort. I tried a sample of five
dates manually and they sorted fine but not when the dates are produced by a
formula. I do not want to have to type in five years of dates as that is the
reason we have formulas. How do I sort the formulated column???????

Relevant Pages

  • How do I sort a column of formulas in Excel?
    ... I then sorted with column A descending and column B (AM/PM) ... so on but the formulated column would not sort. ... reason we have formulas. ...
    (microsoft.public.excel.misc)
  • Re: Module Cruelly Kissed to Death by -O2
    ... It makes a huge difference in a merge sort and brings g95's ... descending 0. ... ascending 0. ...
    (comp.lang.fortran)
  • Re: Sort by clicking on head button
    ... Lets suppose that you want to sort the subform's underlying query ascending ... to have, according of the state of the buttons, acsending or descending ... Private Sub sSortSubForm ...
    (microsoft.public.access.formscoding)
  • Re: Is there a way to reorder groups manually other than ascending
    ... I work in a power plant and I am trying to adapt from Primavera to Microsoft ... Then I would sort on early start. ... but currently I can only sort ascending or descending. ...
    (microsoft.public.project)
  • Re: Way to sort in C++, how? 4 cases
    ... The picture is not terribly informative ... So I need 4 functions to sort. ... If it isn't sorting as you want, ... Fall3 is descending in y and descending in x ...
    (microsoft.public.vc.mfc)