Extracting Selected Data

S

Scott Martin

I need to extract select contacts from a database file
for a mailing. These were contacts that attended a club
meeting in 2000 but not 2001. The database file has
those that attended both meetings listed twice but with a
different year. I don't need to contact all members just
those that did not attend in 2001 but did in 2000. The
feilds of data that I have to work with are SSN, NAME,
ADDRESS AND YEAR ATTENDED.

How do I get Excel to group and select only those that
did not attend in 2001 so I can have only those names and
addresses sent to the printer? The database has over
10,000 contacts in it.
 
K

Kevin M

Scott, you could use AutoFilter. This way, you can filter
out the 2001's leaving only the 2000's. Highlight the
columns, then choose Data > Filter > Autofilter, this
will give you dropdown buttons in your header row.
HTH
Kevin M
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel 2003: Match Names; View Unfound Matches? 1
Function to extract data from a list 2
use sumif / Sumproduct for year data 5
Extract name, address and ph# 8
Repetitive data entry 1
display total in stacked column chart 3
How do I create an attendance register for those present on a date 2

Top