Date Filter

T

tech lead

I have sales data for '05, listed by Customer in random order. Several
customers have entries for '04 as well. I can sort by customer to make
the list alphabetical. How do I filter the list to eliminate the '04
data?
 
M

Max

In the sorted by alpha list,
do a Data > Filter > Autofilter on the dates col,
Select "Custom": is greater than : 31-Dec-2004
 

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

Similar Threads

Date Filter 1
Using a drop-down box to sort data based on seperate columns 2
Multi-select list box 1
Finding most recent date for each customer - XL 2007 2
Insert Blank Line and Sort 3
Find Last Date Invoiced for Each Customer 3
Receiving valid Multicast address failed on mini port driver 0
how do I control the sort order of a filter in a pivot table? 1

Top