re: How do I sort a column of formulas in Excel?
From: Mark (anonymous_at_discussions.microsoft.com)
Date: 11/27/04
- Next message: Mark: "re: Enable Double sided printing contiuously when printing multiple s."
- Previous message: Mark: "re: How to delete repeted rows automaticaly result"
- In reply to: Gordon: "How do I sort a column of formulas in Excel?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Nov 2004 17:55:28 -0800
Hi,
A bad way is to convert the formulas to theair absolute
serial number then reformat them back totheir date format
>-----Original Message-----
>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???????
>.
>
- Next message: Mark: "re: Enable Double sided printing contiuously when printing multiple s."
- Previous message: Mark: "re: How to delete repeted rows automaticaly result"
- In reply to: Gordon: "How do I sort a column of formulas in Excel?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
