• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

Sorting problem

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
snyperj
Asked:
snyperj
  • 2
1 Solution
 
RunriggerCommented:
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
 
snyperjAuthor Commented:
I see... thanks.
0
 
RunriggerCommented:
You are welcome, thanks for the points
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now