LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ray A
 
Posts: n/a
Default Sort with a List

One way
copy the formula times and paste as values in a helper column. Sort on the
values
HTH

"brianwakin" wrote:

I am trying to sort time values using a list. The time values in the cells
are calculated by a formula and not manually entered in. When I try and sort
them assending using a list it doesn't even come close to sorting correctly.
How do you sort using a list when the values are calculated by formulas?
Thanks. Any help would be greatly appreciated.
--
Brian

 
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
find names on list 1 in list 2. list 1 4000 names list 2 400 name Ed Excel Worksheet Functions 1 September 4th 05 12:48 AM
How do you sort a list of dates into date order Tegwen Excel Discussion (Misc queries) 2 August 31st 05 02:04 PM
Update master list with other lists Chab Excel Worksheet Functions 0 August 4th 05 03:46 PM
How do I sort a list of dates in Excel by month and day? Caroline Excel Discussion (Misc queries) 3 June 10th 05 11:58 PM
How to sort a list correctly? Melani New Users to Excel 1 November 29th 04 03:17 PM


All times are GMT +1. The time now is 04:11 AM.

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

About Us

"It's about Microsoft Excel"