Sorting Cells that contain an Array as Dates

S

StaceyJ

Okay, so I finally figured out how to get my array to work. It's inputting
dates that it finds in cells on another tab (looking up based on criteria and
returning all results in seperate cells).

Here is the problem. If I copy the array down only 10 rows, and I have the
filter on, it will still give me the ability to sort the output as dates
(which it should since they ARE dates). However, if I copy it down even 1
more cell, it changes the default sort to "A to Z" and will no longer let me
sort them as dates.

I have to be able to sort them as dates. What should I do?
 
S

StaceyJ

For more clarification on my question:

Instead of giving me the sort options of "Oldest to Newest" and "Newest to
Oldest" it gives me "A to Z" and "Z to A". I'm am using Excel 2007.
 

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

Top