Retrieval of all occurances

[rs2k]

I have a table with multiple duplicate entries. How do I retrieve all occurances for one person.
example,

Book2
	A	B	C	D
1	ActualData
2	name	date	qty
3	joe	01/01/2005	25
4	alan	25/11/2004	36
5	susan	13/01/2005	48
6	alan	01/01/2005	46
7	joe	15/11/2004	65
8	susan	25/11/2004	34
9	joe	17/11/2004	98
10	fred	01/01/2005	12
11
12	RequiredData
13	joe	01/01/2005	25
14	joe	15/11/2004	65
15	joe	17/11/2004	98
16
Sheet1

If joe was typed in A13 then all occurances for him would auto fill the table.
All the posts I've read for MATCH, INDEX and LOOKUP dont seem to answer my problem.

Cheer's
Colin.

 

[bigbob]

Hi
Try clicking one cell inside your table of data and selecting the AUTOFILTER option from the DATA menu and the FILTER sub-menu
Drop down arrows should appear in your headings .Click the drop down arrow and you get a list of all entries in that column .Click any single entry in that list and you get what you require
HTH
Big Bob

 

[yankee428]

Autofilter

Click anywhere in your data. Then, from the menu bar goto Data|Filter|Autofilter. That should put little arrows next to your field names. Pull down and filter for instances of "Joe".

 

[rs2k]

Thanks guys,
A few buttons and it does the job

Colin.