Sorting with a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
My bet is that you have a mixture of real times and times entered as text--that
only look like time.

If you format that column as General, do your cells display numbers between 0
and 1?

(or maybe your cells contain dates and times and your cells are formatted to
show only the time???)
 
If I format the column as general I do have numbers between 0 and 1. My
cells are formatted to show only time (h:mm am/pm). I don't understand what
is going on here. If I hand type the same information in it sorts fine, if
the information is generated with a formula it won't sort right. Any
suggestions or more thoughts on this would be greatly appreciated. Thanks
for your reply.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort with a List 3
sorting: cleared/null v/s "" 3
Problem sorting a range of columns using VBA 1
List sorting and macros 3
How to parse text in a cell 8
Sorting Columns with a Formula 1
Need to flag the lead ID of any contiguous ID's from a sorted list of ID's. 5
Sort with subtotal 1

Back
Top