Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 26th 04, 04:19 PM
Gordon
 
Posts: n/a
Default 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???????

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide column but show chart Svetlana Charts and Charting in Excel 1 January 14th 05 10:49 AM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 08:27 PM
Help with Charting My Data -- DavidM Charts and Charting in Excel 7 January 7th 05 02:08 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 08:25 PM
Making Special "Stacked Column" Chart Chaplain Doug Charts and Charting in Excel 3 December 10th 04 05:31 PM


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017