[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Sorting problem

Posted on 2012-03-23
3
Medium Priority
?
217 Views
Last Modified: 2012-03-23
Hi- I am trying to sort the attached exported data first by work date estimate (col b) ascending (which is fiscal year quarter) and then by Invoice (col c)  descending... but it doesn't seem to sort that way.  What am I missing?

It seems like the work date sorts ok,,though I would rather have the FY14 at the end... but then within the quarters the dollars are not sorting descending.
work-dates.xls
0
Comment
Question by:snyperj
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
Runrigger earned 2000 total points
ID: 37756444
Take a look at the Work Date Est values in cells B13 and B14

the value in 14 has a number of trailing spaces, that's the problem.

B13 = "Q1 - FY13"
B14 = "Q1 - FY13 "
0
 

Author Comment

by:snyperj
ID: 37756834
I see... thanks.
0
 
LVL 11

Expert Comment

by:Runrigger
ID: 37756839
You are welcome, thanks for the points
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

613 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question