I have a large file with many dates. My excel will only let me sort 1000 lines which is only a little over 2 months. I have almost a years worth of data. I found "advanced filter" but dont understand how to sort 1 column.
Excel will certainly sort the whole list. Try selecting all the columns with data and sort again.
As for autofilter, it does not display all unique data if the list is huge. Try using pivottables to extract information you want. Advanced filter is for advanced users so skip that for now.
Blind Dating - How Should you Prepare for This Blind Date?
Related posts:
- How can I sort my sent messages by the TO column and DATE column?
- How to Insert Last Saved date in the footer of Excel 2007?
- online dating number of users
- How do I get my email date/time stamp to show my local time?
- how to create a class \”date\” its memeber data should consists of three ints: month,day,year ?
Excel will certainly sort the whole list. Try selecting all the columns with data and sort again.
As for autofilter, it does not display all unique data if the list is huge. Try using pivottables to extract information you want. Advanced filter is for advanced users so skip that for now.
References :