×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Sorting data in same way as explorer

Sorting data in same way as explorer

Sorting data in same way as explorer

(OP)
Is it possible to sort Excel data in the same way as Windows Explorer?  I realise that Excel has it's own sort rules, but can these be modified in any way (other than just by checking different day or date options)?

RE: Sorting data in same way as explorer

Do you mean in the file open dialog box?

RE: Sorting data in same way as explorer

i do not quite understand the question...

any continuous range of columns can be sorted by criteria choosen while executing the sort command.

are you thinking about filtering data - the auto-filter feature?

please advise.
-pmover

RE: Sorting data in same way as explorer

(OP)
I'll try and explain:

I've got a list of filenames in one column in an Excel sheet (about 200 or so), and I want to sort this column (data/sort command) using the same character order as Windows explorer.

One problem though - I don't know what order that explorer uses to sort the data, I just know that it's different to that used in Excel.

RE: Sorting data in same way as explorer

chunky,

Are you trying to sort these filenames by date?  If yes, are the dates in a column separate from the filenames?  If yes, are they formated as dates or as text?

RE: Sorting data in same way as explorer

I think Explore uses ASCII chr code sort.

Create another column, cause it to contain the ASCII codes for the file names, then sort on that column.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources