| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort with a List
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 |
|
#2
|
|||
|
|||
|
The times generated change all the time. I'm not sure I understand what you
mean. Would you mind explaining how to do this? Thanks for the reply and any further help would be greatly appreciated. Thanks. -- Brian "Ray A" wrote: 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 |
|
#3
|
|||
|
|||
|
Hi Brian,
I am not sure what you mean by times changing all the time but this is what I had in mind. Once the formula calculates you would then convert the results to a value and still retain the formula. Asume your formula is in C2:C10. Highlight C2:C10 EditCopy move to D2 EditPaste SpecialValues. This has done the changed the formula to a result(value). You may now sort on column D HTH "brianwakin" wrote: The times generated change all the time. I'm not sure I understand what you mean. Would you mind explaining how to do this? Thanks for the reply and any further help would be greatly appreciated. Thanks. -- Brian "Ray A" wrote: 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 |
|
#4
|
|||
|
|||
|
Is there a formula/function that accomplishes the same task? Thanks.
-- Brian "Ray A" wrote: Hi Brian, I am not sure what you mean by times changing all the time but this is what I had in mind. Once the formula calculates you would then convert the results to a value and still retain the formula. Asume your formula is in C2:C10. Highlight C2:C10 EditCopy move to D2 EditPaste SpecialValues. This has done the changed the formula to a result(value). You may now sort on column D HTH "brianwakin" wrote: The times generated change all the time. I'm not sure I understand what you mean. Would you mind explaining how to do this? Thanks for the reply and any further help would be greatly appreciated. Thanks. -- Brian "Ray A" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort with a List | Excel Worksheet Functions | |||
| How do you sort a list of dates into date order | Excel Discussion (Misc queries) | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
| How to sort a list correctly? | New Users to Excel | |||
Linear Mode
