Helping Grandma on Local Election ~ Help With Sorting

[foweek]

Hello:

I have 12 Columns
1) Date of Birth is in (MM/DD/YYYY)
2) Date Reg to Vote is in (MM/DD/YYYY)
3) Year of vote or Year of Reg is in (XX)
4) Did they Vote? (Did they vote is in 00, or 01, or 10, or 11)
5) Year of Vote
6) Did they Vote
7 Year of Vote
8) Did they Vote
9) Year of Vote
10) Did they Vote
11) Year of Vote
12) Did they Vote

Ok, here is my problem
I only want to see people that have voted 4 or 5 times
and if they just registered and they voted at least one time I want that name too.

Please Help

 

[SIXTH SENSE]

hi!
care to post using colo's html maker below?
Its quite easy!

 

[foweek]

Full_Book.xls
	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1	DOB	YR_OF_REG	Year	Vote	Year	Vote	Year	Vote	Year	Vote	Year	Vote
2	8/5/1958	12/3/1998	98	00	99	00	00	00	02	00	03	00
3	1/21/1972	8/20/1999	99	00	00	00	02	00	03	00	04	00
4	4/24/1970	2/2/1988	98	00	99	00	00	01	02	00	03	00
5	7/25/1949	7/28/1995	98	00	99	00	00	01	02	00	03	00
6	5/15/1973	10/16/1996	98	00	99	00	00	01	02	00	03	00
7	12/29/1946	12/19/1997	98	00	99	00	00	00	02	00	03	00
8	8/20/1960	10/28/1987	98	00	99	00	00	00	02	00	03	00
9	5/7/1958	10/28/1987	98	00	99	00	00	00	02	00	03	00
FULL_BOOK

Here is some sample data

 

[Juan Pablo González]

I don't understand that table...

Care to explain the first record for example ? why is 00 in all the 'Vote' columns ?

 

[foweek]

00 represents NO vote
01 or 10 or 11 represents a vote

 

[SIXTH SENSE]

hi!
you can add one column in the right and count the numbers of voting times they made. then autofilter it using the last column as criteria.

see below.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	DOB	YR_OF_REG	Year	Vote	Year	Vote	Year	Vote	Year	Vote	Year	Vote	Noofvotingtime
2	August5,1958	December3,1998	98	00	99	00	00	00	02	00	03	00	0
3	January21,1972	August20,1999	99	00	00	00	02	00	03	00	04	00	0
4	April24,1970	February2,1988	98	00	99	00	00	01	02	00	03	00	1
5	July25,1949	July28,1995	98	00	99	00	00	01	02	00	03	00	1
6	May15,1973	October16,1996	98	00	99	00	00	01	02	00	03	00	1
7	December29,1946	December19,1997	98	00	99	00	00	00	02	00	03	00	0
8	August20,1960	October28,1987	98	00	99	00	00	00	02	00	03	00	0
9	May7,1958	October28,1987	98	00	99	00	00	00	02	00	03	00	0
Sheet3