Remember Me?

#1
November 26th 04, 03:19 PM
 Gordon Posts: n/a
How do I sort a column of formulas in Excel?

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???????

#2
November 26th 04, 03:59 PM
 Gary Fuller Posts: n/a

HI Gordon, I am rather new at this, but did you try selecting all of the
cells, copying, then paste special, paste values, then the sort? THere is
probably some better way, but it worked for me.
Gary

"Gordon" wrote:

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???????

#3
November 27th 04, 01:55 AM
 Mark Posts: n/a

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???????
.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Svetlana Charts and Charting in Excel 1 January 14th 05 09:49 AM Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM Chaplain Doug Charts and Charting in Excel 3 December 10th 04 04:31 PM Gordon Excel Discussion (Misc queries) 0 November 26th 04 03:19 PM

All times are GMT +1. The time now is 05:24 PM.