A loop question, I think.

[Tmcvicar]

Stuck at home after a devastating injury. Put together a excel spreadsheet of youth track races in my county, just to pass the time. Decided I wanted to pull out various bits of data from the spreadsheet but got tired of scrolling through it and writing down what I was looking for. Decided I would learn VBA and write quick programs to find what I was looking for. Discovered (I bought the standard books - for dummies, power programming etc) that I had no idea what I was doing, since I am not a programmer at all. (The last programming I did was between 7th and 8th grade in 1981, at summer camp, 4 and 5 line basic programs).

My question is:
How do I proceed through a list of dates and races to find, for instance, the races where a runner was the only freshman in a race?

I managed to figure out how to proceed through the list and find the freshmen but I cant seem to differentiate each day and each race and if the runner was the only freshman in the race? I don't know how to make the program treat each race on each day as a separate event without running the macro/vba code for each individual race/date.

I'm not even sure my question makes sense.

Pasted below is a condensed example of my spreadsheet with made up names etc.

DATE	RACE	RUNNER	YEAR
1/1/13	55	MCVICAR	FR
1/1/13	55	ONTOS	SO
1/1/13	55	JEBEL	SO
1/1/13	55	LUREY	JR
1/1/13	55	SAMMS	SR
1/1/13	100	MCVICAR	FR
1/1/13	100	TELL	FR
1/1/13	100	ZIMP	FR
1/1/13	100	TOAF	SO
1/1/13	100	ZILLY	SR
1/1/13	220	ARSNAULT	FR
1/1/13	220	ILLY	SO
1/1/13	220	CONUTER	SO
1/1/13	220	DELBY	SO
1/1/13	220	ELMORE	JR
1/1/13	440	FULLER	FR
1/1/13	440	GOND	FR
1/1/13	440	HELLER	SO
1/1/13	440	INDIAN	JR
1/1/13	440	KUGEL	SR
1/1/13	880	NARUTA	JR
1/1/13	880	PENGUIN	JR
1/1/13	880	QUINTANILLA	JR
1/1/13	880	ROMERO	SR
1/1/13	880	SLOW	FR
1/1/13	1600	TEMPER	FR
1/1/13	1600	UNIFORE	FR
1/1/13	1600	VENDAT	JR
1/1/13	1600	WILBUR	SO
1/1/13	1600	XANTHAM	SO
1/1/13	3200	YOLI	SR
1/1/13	3200	ZEROI	FR
1/1/13	3200	AMPLA	SO
1/1/13	3200	BTUDE	JR
1/1/13	3200	CRUSH	SR
1/8/13	55	MCVICAR	FR
1/8/13	55	ONTOS	SO
1/8/13	55	JEBEL	SO
1/8/13	55	LUREY	JR
1/8/13	55	SAMMS	SR
1/8/13	100	MCVICAR	FR
1/8/13	100	TELL	FR
1/8/13	100	ZIMP	FR
1/8/13	100	TOAF	SO
1/8/13	100	ZILLY	SR
1/8/13	220	ARSNAULT	FR
1/8/13	220	ILLY	SO
1/8/13	220	CONUTER	SO
1/8/13	220	DELBY	SO
1/8/13	220	ELMORE	JR
1/8/13	440	FULLER	FR
1/8/13	440	GOND	FR
1/8/13	440	HELLER	SO
1/8/13	440	INDIAN	JR
1/8/13	440	KUGEL	SR
1/8/13	880	NARUTA	JR
1/8/13	880	PENGUIN	JR
1/8/13	880	QUINTANILLA	JR
1/8/13	880	ROMERO	SR
1/8/13	880	SLOW	FR
1/8/13	1600	TEMPER	FR
1/8/13	1600	UNIFORE	FR
1/8/13	1600	VENDAT	JR
1/8/13	1600	WILBUR	SO
1/8/13	1600	XANTHAM	SO
1/8/13	3200	YOLI	SR
1/8/13	3200	ZEROI	FR
1/8/13	3200	AMPLA	SO
1/8/13	3200	BTUDE	JR
Thanks in advance. TMCVICAR

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[Scott Huish]

Why VBA? I think you could use Filter for what you are trying to do.

 

[Tmcvicar]

Oh My. That works. Thank you.