sorting

Lowggy

New Member
Joined
Mar 3, 2018
Messages
39
I have and excel file with about 200 rows. Consecutive columns have cells with last name, first name but in between those pairs of couple there are single names. I want to sort the file in alphabetical order keeping all the couples together and listing the single names at the end and of course keeping all the other columns in tact.
 
Nobody on this thread has suggested you upload a file to dropbox that I can see.
Also as you have not supplied a link, there is no way anyone can look at it ;)
 
Upvote 0

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
is that what you want to achieve?

example:

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#F79646]Index[/td][td=bgcolor:#F79646]name[/td][td=bgcolor:#F79646]handicap[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
0​
[/td][td=bgcolor:#FDE9D9]SOCZKA, CARLA[/td][td=bgcolor:#FDE9D9]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
0​
[/td][td]SOCZKA, CLARENCE[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
0​
[/td][td=bgcolor:#FDE9D9]MATEER, DONNA[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
0​
[/td][td]MATEER, DAN[/td][td]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
1​
[/td][td=bgcolor:#FDE9D9]REIER, BOB[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
1​
[/td][td]REIER, PHYLISS[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
1​
[/td][td=bgcolor:#FDE9D9]WALLER, MARY ANN[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
1​
[/td][td]WALLER, ROY[/td][td]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
2​
[/td][td=bgcolor:#FDE9D9]LEWIS, JUDY*[/td][td=bgcolor:#FDE9D9]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
2​
[/td][td]LEWIS, CHARLIE*[/td][td]
2​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
2​
[/td][td=bgcolor:#FDE9D9]LARSEN, PAM*[/td][td=bgcolor:#FDE9D9]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
2​
[/td][td]LARSEN, RON*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
3​
[/td][td=bgcolor:#FDE9D9]RICHEY, LINDA Y*[/td][td=bgcolor:#FDE9D9]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
3​
[/td][td]RICHEY, MORRIS*[/td][td]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
3​
[/td][td=bgcolor:#FDE9D9]FRALEY, KAREN[/td][td=bgcolor:#FDE9D9]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
3​
[/td][td]FRALEY, LONNIE[/td][td]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
4​
[/td][td=bgcolor:#FDE9D9]BEIERLE, CAROLYN*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
4​
[/td][td]BEIERLE, BOB*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
4​
[/td][td=bgcolor:#FDE9D9]BERGER, TODD[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
4​
[/td][td]BERGER, RHONDA[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
5​
[/td][td=bgcolor:#FDE9D9]BUCHHOLZ, MARIE[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
5​
[/td][td]BUCHHOLZ, RUDY[/td][td]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
5​
[/td][td=bgcolor:#FDE9D9]THOMAS, LINNEA[/td][td=bgcolor:#FDE9D9]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
5​
[/td][td]THOMAS, JACK*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
6​
[/td][td=bgcolor:#FDE9D9]BADGER, LYN*[/td][td=bgcolor:#FDE9D9]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
6​
[/td][td]BADGER, JIM*[/td][td]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
6​
[/td][td=bgcolor:#FDE9D9]VANBIBBER, WALT[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
6​
[/td][td]VANBIBBER, CONNIE[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
7​
[/td][td=bgcolor:#FDE9D9]KLIT, ESTHER*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
7​
[/td][td]KLIT, EARL*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
7​
[/td][td=bgcolor:#FDE9D9]PRUNER, MERLE[/td][td=bgcolor:#FDE9D9]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
7​
[/td][td]PRUNER, SHIRLEY[/td][td]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
8​
[/td][td=bgcolor:#FDE9D9]COOPER, NORM[/td][td=bgcolor:#FDE9D9]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
8​
[/td][td]COOPER, JOAN JACKLIN[/td][td]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
8​
[/td][td=bgcolor:#FDE9D9]WOOD, LYLE[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
8​
[/td][td]WOOD, DORTHY[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
9​
[/td][td=bgcolor:#FDE9D9]WOLFE, SHARON*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
9​
[/td][td]WOLFE, WILLIE*[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
9​
[/td][td=bgcolor:#FDE9D9]RYZSKI, HANK[/td][td=bgcolor:#FDE9D9]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
9​
[/td][td]RYZSKI, LOIS[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
10​
[/td][td=bgcolor:#FDE9D9]STEWART, DONALD*[/td][td=bgcolor:#FDE9D9]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
10​
[/td][td]STEWART, KARENE*[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
10​
[/td][td=bgcolor:#FDE9D9]SMILEY, NANCY*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
10​
[/td][td]SMILEY, JACK*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
11​
[/td][td=bgcolor:#FDE9D9]LEISSES, ****[/td][td=bgcolor:#FDE9D9]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
11​
[/td][td]LEISSES, JANE[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
11​
[/td][td=bgcolor:#FDE9D9]YETTO, KAREN*[/td][td=bgcolor:#FDE9D9]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
11​
[/td][td]YETTO, WAYNE*[/td][td]
6​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
12​
[/td][td=bgcolor:#FDE9D9]WILLIAMS, BEVERLY[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
12​
[/td][td]WILLIAMS, BOB[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
12​
[/td][td=bgcolor:#FDE9D9]O'CONNER, GLENDA[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
12​
[/td][td]O'CONNER, PETE[/td][td]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
13​
[/td][td=bgcolor:#FDE9D9]HOLLAND, RONALD*[/td][td=bgcolor:#FDE9D9]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
13​
[/td][td]HOLLAND, PAT[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
13​
[/td][td=bgcolor:#FDE9D9]MANN, NORMA*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
13​
[/td][td]MANN, EARL*[/td][td]
7​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
14​
[/td][td=bgcolor:#FDE9D9]BERGERON, LESLIE[/td][td=bgcolor:#FDE9D9]
7​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
14​
[/td][td]BERGERON, MAURICE[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
14​
[/td][td=bgcolor:#FDE9D9]UTZ, ANN[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
14​
[/td][td]UTZ, ED[/td][td]
7​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
15​
[/td][td=bgcolor:#FDE9D9]Q'TRMAINE, MARY*[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15​
[/td][td]Q'TRMAINE, JERRY*[/td][td]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
15​
[/td][td=bgcolor:#FDE9D9]COPPO, DON*[/td][td=bgcolor:#FDE9D9]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15​
[/td][td]COPPO, CHERYL*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
16​
[/td][td=bgcolor:#FDE9D9]TAMBAKIS, PAUL*[/td][td=bgcolor:#FDE9D9]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
16​
[/td][td]TAMBAKIS, CARMEN*[/td][td]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
16​
[/td][td=bgcolor:#FDE9D9]UPENIECKS, EMO[/td][td=bgcolor:#FDE9D9]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
16​
[/td][td]UPENIECKS, CAROL[/td][td]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
17​
[/td][td=bgcolor:#FDE9D9]MCNAMARA, CONNY[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
17​
[/td][td]MCNAMARA, DAVE[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
17​
[/td][td=bgcolor:#FDE9D9]RICHARDSON, PHIL*[/td][td=bgcolor:#FDE9D9]
2​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
17​
[/td][td]RICHARDSON, RUTH*[/td][td]
4​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
18​
[/td][td=bgcolor:#FDE9D9]SUTFIN, MURIAL[/td][td=bgcolor:#FDE9D9]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
18​
[/td][td]SUTFIN, LOU[/td][td]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
18​
[/td][td=bgcolor:#FDE9D9]MCSHANE, TOM[/td][td=bgcolor:#FDE9D9]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
18​
[/td][td]MCSHANE, JUDY[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
19​
[/td][td=bgcolor:#FDE9D9]GASSEK, CHARLES*[/td][td=bgcolor:#FDE9D9]
5​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
19​
[/td][td]GASSEK, VICKY*[/td][td]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
19​
[/td][td=bgcolor:#FDE9D9]EISENHART, SUE[/td][td=bgcolor:#FDE9D9]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
19​
[/td][td]EISENHART, CHUCK[/td][td]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
20​
[/td][td=bgcolor:#FDE9D9]NELSON, LOU[/td][td=bgcolor:#FDE9D9]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
20​
[/td][td]NELSON, BOB[/td][td]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
20​
[/td][td=bgcolor:#FDE9D9]WELDON, JANE*[/td][td=bgcolor:#FDE9D9]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
20​
[/td][td]WELDON, TIM*[/td][td]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
21​
[/td][td=bgcolor:#FDE9D9]HRABETS, HERB[/td][td=bgcolor:#FDE9D9]
5​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
21​
[/td][td]HRABETS, MARY[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
21​
[/td][td=bgcolor:#FDE9D9]KARNES, JOE*[/td][td=bgcolor:#FDE9D9]
6​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
21​
[/td][td]KARNES, SHARON*[/td][td]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
22​
[/td][td=bgcolor:#FDE9D9]FOX, TERRI*[/td][td=bgcolor:#FDE9D9]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
22​
[/td][td]FOX, FRANCIS*[/td][td]
6​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
22​
[/td][td=bgcolor:#FDE9D9]JACKSON, TOM[/td][td=bgcolor:#FDE9D9]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
22​
[/td][td]JACKSON,TAMMY[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
23​
[/td][td=bgcolor:#FDE9D9]ELLIS, LINDA[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
23​
[/td][td]ELLIS, JIM[/td][td]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
23​
[/td][td=bgcolor:#FDE9D9]MATTSON, KATHLEEN[/td][td=bgcolor:#FDE9D9]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
23​
[/td][td]MATTSON, LELAND[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
24​
[/td][td=bgcolor:#FDE9D9]KOMRO, JACK[/td][td=bgcolor:#FDE9D9]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
24​
[/td][td]KOMRO, CAROLE[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
24​
[/td][td=bgcolor:#FDE9D9]CAMPBELL, CARLOYN[/td][td=bgcolor:#FDE9D9]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
24​
[/td][td]CAMPBELL, RULE*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
25​
[/td][td=bgcolor:#FDE9D9]SIMMONS, JERRI*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
25​
[/td][td]SIMMONS, JIM*[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
25​
[/td][td=bgcolor:#FDE9D9]MANNIS, LINDA*[/td][td=bgcolor:#FDE9D9]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
25​
[/td][td]MANIS, JOHN*[/td][td]
4​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
26​
[/td][td=bgcolor:#FDE9D9]TAYLOR, JAKE[/td][td=bgcolor:#FDE9D9]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
26​
[/td][td]TAYLOR, SUE*[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
26​
[/td][td=bgcolor:#FDE9D9]HURLEY, ANN*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
26​
[/td][td]HURLEY, PETER*[/td][td]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
27​
[/td][td=bgcolor:#FDE9D9]ALFORD, RUTH[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
27​
[/td][td]ALFORD, JIM[/td][td]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
27​
[/td][td=bgcolor:#FDE9D9]FULMER, DAVE[/td][td=bgcolor:#FDE9D9]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
27​
[/td][td]FULMER, CAROL*[/td][td]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
28​
[/td][td=bgcolor:#FDE9D9]DALTON, KAY[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
28​
[/td][td]DALTON, JACK[/td][td]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
28​
[/td][td=bgcolor:#FDE9D9]PINTER ,LESS[/td][td=bgcolor:#FDE9D9]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
28​
[/td][td]PINTER, DEBBIE[/td][td]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
29​
[/td][td=bgcolor:#FDE9D9]HOOVER, BILL[/td][td=bgcolor:#FDE9D9]
12​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
29​
[/td][td]HOOVER, CAROL[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
29​
[/td][td=bgcolor:#FDE9D9]BURK, SHARON[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
29​
[/td][td]BURK, CHUCK[/td][td]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
30​
[/td][td=bgcolor:#FDE9D9]CREWS, BONNIE[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
30​
[/td][td]CREWS, MORRIS[/td][td]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
30​
[/td][td=bgcolor:#FDE9D9]LAMERS, JOHN[/td][td=bgcolor:#FDE9D9]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
30​
[/td][td]LAMERS, MARY[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
31​
[/td][td=bgcolor:#FDE9D9]FULTON, TERRY[/td][td=bgcolor:#FDE9D9]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
31​
[/td][td]FULTON, JOANNE[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
31​
[/td][td=bgcolor:#FDE9D9]MOHLER, BOB[/td][td=bgcolor:#FDE9D9]
7​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
31​
[/td][td]MOHLER, BEV[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
32​
[/td][td=bgcolor:#FDE9D9]GAFFNEY, MARGIE[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
32​
[/td][td]GAFFNEY, FRED[/td][td]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
32​
[/td][td=bgcolor:#FDE9D9]SENNETT, CHUCK[/td][td=bgcolor:#FDE9D9]
3​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
32​
[/td][td]SENNETT, ESTHER[/td][td]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
33​
[/td][td=bgcolor:#FDE9D9]GAUSE, SHIRLEY[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
33​
[/td][td]GAUSE, JIM[/td][td]
7​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
33​
[/td][td=bgcolor:#FDE9D9]KALKBRENNER, LINDA*[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
33​
[/td][td]KALKBRENNER, LENNY*[/td][td]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
34​
[/td][td=bgcolor:#FDE9D9]WRIGHT, SANDRA[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
34​
[/td][td]WRIGHT, PHILLIP[/td][td]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
34​
[/td][td=bgcolor:#FDE9D9]HAWK, SUSIE[/td][td=bgcolor:#FDE9D9]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
34​
[/td][td]HAWK, JIM[/td][td]
7​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
35​
[/td][td=bgcolor:#FDE9D9]OSTERHOUT, JIM*[/td][td=bgcolor:#FDE9D9]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
35​
[/td][td]OSTERHOUT, MARY ALICE*[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
35​
[/td][td=bgcolor:#FDE9D9]CLOUD, ****[/td][td=bgcolor:#FDE9D9]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
35​
[/td][td]CLOUD, GLORIA[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
36​
[/td][td=bgcolor:#FDE9D9]EICH, LEROY[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
36​
[/td][td]EICH, LINDA[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
36​
[/td][td=bgcolor:#FDE9D9]ROUSH, MIC[/td][td=bgcolor:#FDE9D9]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
36​
[/td][td]ROUSH, JANE[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
37​
[/td][td=bgcolor:#FDE9D9]ALMASI, CAROL*[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
37​
[/td][td]ALMASI, DENNIS*[/td][td]
6​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
37​
[/td][td=bgcolor:#FDE9D9]MILLER, DAN[/td][td=bgcolor:#FDE9D9]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
37​
[/td][td]MILLER, LARAINE[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
38​
[/td][td=bgcolor:#FDE9D9]VANDENBERG, RAY[/td][td=bgcolor:#FDE9D9]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
38​
[/td][td]VANDERBURG, BETTY[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
38​
[/td][td=bgcolor:#FDE9D9]LOGAN, RANDY*[/td][td=bgcolor:#FDE9D9]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
38​
[/td][td]LOGAN, SHARON*[/td][td]
10​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
39​
[/td][td=bgcolor:#FDE9D9]GOODHUE, MARTHA[/td][td=bgcolor:#FDE9D9]
14​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
39​
[/td][td]GOODHUE, JIM[/td][td]
13​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FDE9D9]
39​
[/td][td=bgcolor:#FDE9D9]REID, ERNIE[/td][td=bgcolor:#FDE9D9]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
39​
[/td][td]REID, MARLENE*[/td][td]
17​
[/td][/tr]
[/table]
 
Last edited:
Upvote 0
is that what you want to achieve?

example:

[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #F79646"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Index[/COLOR][/TD]
[TD="bgcolor: #F79646"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]name[/COLOR][/TD]
[TD="bgcolor: #F79646"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]handicap[/COLOR][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
0​
[/TD]
[TD="bgcolor: #FDE9D9"]SOCZKA, CARLA[/TD]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
0​
[/TD]
[TD]SOCZKA, CLARENCE[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
0​
[/TD]
[TD="bgcolor: #FDE9D9"]MATEER, DONNA[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
0​
[/TD]
[TD]MATEER, DAN[/TD]
[TD]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
1​
[/TD]
[TD="bgcolor: #FDE9D9"]REIER, BOB[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
1​
[/TD]
[TD]REIER, PHYLISS[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
1​
[/TD]
[TD="bgcolor: #FDE9D9"]WALLER, MARY ANN[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
1​
[/TD]
[TD]WALLER, ROY[/TD]
[TD]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
2​
[/TD]
[TD="bgcolor: #FDE9D9"]LEWIS, JUDY*[/TD]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
2​
[/TD]
[TD]LEWIS, CHARLIE*[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
2​
[/TD]
[TD="bgcolor: #FDE9D9"]LARSEN, PAM*[/TD]
[TD="bgcolor: #FDE9D9"]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
2​
[/TD]
[TD]LARSEN, RON*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
3​
[/TD]
[TD="bgcolor: #FDE9D9"]RICHEY, LINDA Y*[/TD]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
3​
[/TD]
[TD]RICHEY, MORRIS*[/TD]
[TD]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
3​
[/TD]
[TD="bgcolor: #FDE9D9"]FRALEY, KAREN[/TD]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
3​
[/TD]
[TD]FRALEY, LONNIE[/TD]
[TD]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
4​
[/TD]
[TD="bgcolor: #FDE9D9"]BEIERLE, CAROLYN*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
4​
[/TD]
[TD]BEIERLE, BOB*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
4​
[/TD]
[TD="bgcolor: #FDE9D9"]BERGER, TODD[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
4​
[/TD]
[TD]BERGER, RHONDA[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
5​
[/TD]
[TD="bgcolor: #FDE9D9"]BUCHHOLZ, MARIE[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
5​
[/TD]
[TD]BUCHHOLZ, RUDY[/TD]
[TD]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
5​
[/TD]
[TD="bgcolor: #FDE9D9"]THOMAS, LINNEA[/TD]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
5​
[/TD]
[TD]THOMAS, JACK*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
6​
[/TD]
[TD="bgcolor: #FDE9D9"]BADGER, LYN*[/TD]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
6​
[/TD]
[TD]BADGER, JIM*[/TD]
[TD]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
6​
[/TD]
[TD="bgcolor: #FDE9D9"]VANBIBBER, WALT[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
6​
[/TD]
[TD]VANBIBBER, CONNIE[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
7​
[/TD]
[TD="bgcolor: #FDE9D9"]KLIT, ESTHER*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
7​
[/TD]
[TD]KLIT, EARL*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
7​
[/TD]
[TD="bgcolor: #FDE9D9"]PRUNER, MERLE[/TD]
[TD="bgcolor: #FDE9D9"]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
7​
[/TD]
[TD]PRUNER, SHIRLEY[/TD]
[TD]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[TD="bgcolor: #FDE9D9"]COOPER, NORM[/TD]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
8​
[/TD]
[TD]COOPER, JOAN JACKLIN[/TD]
[TD]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[TD="bgcolor: #FDE9D9"]WOOD, LYLE[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
8​
[/TD]
[TD]WOOD, DORTHY[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
9​
[/TD]
[TD="bgcolor: #FDE9D9"]WOLFE, SHARON*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
9​
[/TD]
[TD]WOLFE, WILLIE*[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
9​
[/TD]
[TD="bgcolor: #FDE9D9"]RYZSKI, HANK[/TD]
[TD="bgcolor: #FDE9D9"]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
9​
[/TD]
[TD]RYZSKI, LOIS[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
10​
[/TD]
[TD="bgcolor: #FDE9D9"]STEWART, DONALD*[/TD]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
10​
[/TD]
[TD]STEWART, KARENE*[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
10​
[/TD]
[TD="bgcolor: #FDE9D9"]SMILEY, NANCY*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
10​
[/TD]
[TD]SMILEY, JACK*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[TD="bgcolor: #FDE9D9"]LEISSES, ****[/TD]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
11​
[/TD]
[TD]LEISSES, JANE[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[TD="bgcolor: #FDE9D9"]YETTO, KAREN*[/TD]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
11​
[/TD]
[TD]YETTO, WAYNE*[/TD]
[TD]
6​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
12​
[/TD]
[TD="bgcolor: #FDE9D9"]WILLIAMS, BEVERLY[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
12​
[/TD]
[TD]WILLIAMS, BOB[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
12​
[/TD]
[TD="bgcolor: #FDE9D9"]O'CONNER, GLENDA[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
12​
[/TD]
[TD]O'CONNER, PETE[/TD]
[TD]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[TD="bgcolor: #FDE9D9"]HOLLAND, RONALD*[/TD]
[TD="bgcolor: #FDE9D9"]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
13​
[/TD]
[TD]HOLLAND, PAT[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[TD="bgcolor: #FDE9D9"]MANN, NORMA*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
13​
[/TD]
[TD]MANN, EARL*[/TD]
[TD]
7​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[TD="bgcolor: #FDE9D9"]BERGERON, LESLIE[/TD]
[TD="bgcolor: #FDE9D9"]
7​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
14​
[/TD]
[TD]BERGERON, MAURICE[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[TD="bgcolor: #FDE9D9"]UTZ, ANN[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
14​
[/TD]
[TD]UTZ, ED[/TD]
[TD]
7​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
15​
[/TD]
[TD="bgcolor: #FDE9D9"]Q'TRMAINE, MARY*[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
15​
[/TD]
[TD]Q'TRMAINE, JERRY*[/TD]
[TD]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
15​
[/TD]
[TD="bgcolor: #FDE9D9"]COPPO, DON*[/TD]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
15​
[/TD]
[TD]COPPO, CHERYL*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[TD="bgcolor: #FDE9D9"]TAMBAKIS, PAUL*[/TD]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
16​
[/TD]
[TD]TAMBAKIS, CARMEN*[/TD]
[TD]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[TD="bgcolor: #FDE9D9"]UPENIECKS, EMO[/TD]
[TD="bgcolor: #FDE9D9"]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
16​
[/TD]
[TD]UPENIECKS, CAROL[/TD]
[TD]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[TD="bgcolor: #FDE9D9"]MCNAMARA, CONNY[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
17​
[/TD]
[TD]MCNAMARA, DAVE[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[TD="bgcolor: #FDE9D9"]RICHARDSON, PHIL*[/TD]
[TD="bgcolor: #FDE9D9"]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
17​
[/TD]
[TD]RICHARDSON, RUTH*[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
18​
[/TD]
[TD="bgcolor: #FDE9D9"]SUTFIN, MURIAL[/TD]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
18​
[/TD]
[TD]SUTFIN, LOU[/TD]
[TD]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
18​
[/TD]
[TD="bgcolor: #FDE9D9"]MCSHANE, TOM[/TD]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
18​
[/TD]
[TD]MCSHANE, JUDY[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
19​
[/TD]
[TD="bgcolor: #FDE9D9"]GASSEK, CHARLES*[/TD]
[TD="bgcolor: #FDE9D9"]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
19​
[/TD]
[TD]GASSEK, VICKY*[/TD]
[TD]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
19​
[/TD]
[TD="bgcolor: #FDE9D9"]EISENHART, SUE[/TD]
[TD="bgcolor: #FDE9D9"]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
19​
[/TD]
[TD]EISENHART, CHUCK[/TD]
[TD]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
20​
[/TD]
[TD="bgcolor: #FDE9D9"]NELSON, LOU[/TD]
[TD="bgcolor: #FDE9D9"]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
20​
[/TD]
[TD]NELSON, BOB[/TD]
[TD]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
20​
[/TD]
[TD="bgcolor: #FDE9D9"]WELDON, JANE*[/TD]
[TD="bgcolor: #FDE9D9"]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
20​
[/TD]
[TD]WELDON, TIM*[/TD]
[TD]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
21​
[/TD]
[TD="bgcolor: #FDE9D9"]HRABETS, HERB[/TD]
[TD="bgcolor: #FDE9D9"]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
21​
[/TD]
[TD]HRABETS, MARY[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
21​
[/TD]
[TD="bgcolor: #FDE9D9"]KARNES, JOE*[/TD]
[TD="bgcolor: #FDE9D9"]
6​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
21​
[/TD]
[TD]KARNES, SHARON*[/TD]
[TD]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
22​
[/TD]
[TD="bgcolor: #FDE9D9"]FOX, TERRI*[/TD]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
22​
[/TD]
[TD]FOX, FRANCIS*[/TD]
[TD]
6​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
22​
[/TD]
[TD="bgcolor: #FDE9D9"]JACKSON, TOM[/TD]
[TD="bgcolor: #FDE9D9"]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
22​
[/TD]
[TD]JACKSON,TAMMY[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
23​
[/TD]
[TD="bgcolor: #FDE9D9"]ELLIS, LINDA[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
23​
[/TD]
[TD]ELLIS, JIM[/TD]
[TD]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
23​
[/TD]
[TD="bgcolor: #FDE9D9"]MATTSON, KATHLEEN[/TD]
[TD="bgcolor: #FDE9D9"]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
23​
[/TD]
[TD]MATTSON, LELAND[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
24​
[/TD]
[TD="bgcolor: #FDE9D9"]KOMRO, JACK[/TD]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
24​
[/TD]
[TD]KOMRO, CAROLE[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
24​
[/TD]
[TD="bgcolor: #FDE9D9"]CAMPBELL, CARLOYN[/TD]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
24​
[/TD]
[TD]CAMPBELL, RULE*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
25​
[/TD]
[TD="bgcolor: #FDE9D9"]SIMMONS, JERRI*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
25​
[/TD]
[TD]SIMMONS, JIM*[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
25​
[/TD]
[TD="bgcolor: #FDE9D9"]MANNIS, LINDA*[/TD]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
25​
[/TD]
[TD]MANIS, JOHN*[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
26​
[/TD]
[TD="bgcolor: #FDE9D9"]TAYLOR, JAKE[/TD]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
26​
[/TD]
[TD]TAYLOR, SUE*[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
26​
[/TD]
[TD="bgcolor: #FDE9D9"]HURLEY, ANN*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
26​
[/TD]
[TD]HURLEY, PETER*[/TD]
[TD]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
27​
[/TD]
[TD="bgcolor: #FDE9D9"]ALFORD, RUTH[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
27​
[/TD]
[TD]ALFORD, JIM[/TD]
[TD]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
27​
[/TD]
[TD="bgcolor: #FDE9D9"]FULMER, DAVE[/TD]
[TD="bgcolor: #FDE9D9"]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
27​
[/TD]
[TD]FULMER, CAROL*[/TD]
[TD]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
28​
[/TD]
[TD="bgcolor: #FDE9D9"]DALTON, KAY[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
28​
[/TD]
[TD]DALTON, JACK[/TD]
[TD]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
28​
[/TD]
[TD="bgcolor: #FDE9D9"]PINTER ,LESS[/TD]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
28​
[/TD]
[TD]PINTER, DEBBIE[/TD]
[TD]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
29​
[/TD]
[TD="bgcolor: #FDE9D9"]HOOVER, BILL[/TD]
[TD="bgcolor: #FDE9D9"]
12​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
29​
[/TD]
[TD]HOOVER, CAROL[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
29​
[/TD]
[TD="bgcolor: #FDE9D9"]BURK, SHARON[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
29​
[/TD]
[TD]BURK, CHUCK[/TD]
[TD]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
30​
[/TD]
[TD="bgcolor: #FDE9D9"]CREWS, BONNIE[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
30​
[/TD]
[TD]CREWS, MORRIS[/TD]
[TD]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
30​
[/TD]
[TD="bgcolor: #FDE9D9"]LAMERS, JOHN[/TD]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
30​
[/TD]
[TD]LAMERS, MARY[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
31​
[/TD]
[TD="bgcolor: #FDE9D9"]FULTON, TERRY[/TD]
[TD="bgcolor: #FDE9D9"]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
31​
[/TD]
[TD]FULTON, JOANNE[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
31​
[/TD]
[TD="bgcolor: #FDE9D9"]MOHLER, BOB[/TD]
[TD="bgcolor: #FDE9D9"]
7​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
31​
[/TD]
[TD]MOHLER, BEV[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
32​
[/TD]
[TD="bgcolor: #FDE9D9"]GAFFNEY, MARGIE[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
32​
[/TD]
[TD]GAFFNEY, FRED[/TD]
[TD]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
32​
[/TD]
[TD="bgcolor: #FDE9D9"]SENNETT, CHUCK[/TD]
[TD="bgcolor: #FDE9D9"]
3​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
32​
[/TD]
[TD]SENNETT, ESTHER[/TD]
[TD]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
33​
[/TD]
[TD="bgcolor: #FDE9D9"]GAUSE, SHIRLEY[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
33​
[/TD]
[TD]GAUSE, JIM[/TD]
[TD]
7​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
33​
[/TD]
[TD="bgcolor: #FDE9D9"]KALKBRENNER, LINDA*[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
33​
[/TD]
[TD]KALKBRENNER, LENNY*[/TD]
[TD]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
34​
[/TD]
[TD="bgcolor: #FDE9D9"]WRIGHT, SANDRA[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
34​
[/TD]
[TD]WRIGHT, PHILLIP[/TD]
[TD]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
34​
[/TD]
[TD="bgcolor: #FDE9D9"]HAWK, SUSIE[/TD]
[TD="bgcolor: #FDE9D9"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
34​
[/TD]
[TD]HAWK, JIM[/TD]
[TD]
7​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
35​
[/TD]
[TD="bgcolor: #FDE9D9"]OSTERHOUT, JIM*[/TD]
[TD="bgcolor: #FDE9D9"]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
35​
[/TD]
[TD]OSTERHOUT, MARY ALICE*[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
35​
[/TD]
[TD="bgcolor: #FDE9D9"]CLOUD, ****[/TD]
[TD="bgcolor: #FDE9D9"]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
35​
[/TD]
[TD]CLOUD, GLORIA[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
36​
[/TD]
[TD="bgcolor: #FDE9D9"]EICH, LEROY[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
36​
[/TD]
[TD]EICH, LINDA[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
36​
[/TD]
[TD="bgcolor: #FDE9D9"]ROUSH, MIC[/TD]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
36​
[/TD]
[TD]ROUSH, JANE[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
37​
[/TD]
[TD="bgcolor: #FDE9D9"]ALMASI, CAROL*[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
37​
[/TD]
[TD]ALMASI, DENNIS*[/TD]
[TD]
6​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
37​
[/TD]
[TD="bgcolor: #FDE9D9"]MILLER, DAN[/TD]
[TD="bgcolor: #FDE9D9"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
37​
[/TD]
[TD]MILLER, LARAINE[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
38​
[/TD]
[TD="bgcolor: #FDE9D9"]VANDENBERG, RAY[/TD]
[TD="bgcolor: #FDE9D9"]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
38​
[/TD]
[TD]VANDERBURG, BETTY[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
38​
[/TD]
[TD="bgcolor: #FDE9D9"]LOGAN, RANDY*[/TD]
[TD="bgcolor: #FDE9D9"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
38​
[/TD]
[TD]LOGAN, SHARON*[/TD]
[TD]
10​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
39​
[/TD]
[TD="bgcolor: #FDE9D9"]GOODHUE, MARTHA[/TD]
[TD="bgcolor: #FDE9D9"]
14​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
39​
[/TD]
[TD]GOODHUE, JIM[/TD]
[TD]
13​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FDE9D9"]
39​
[/TD]
[TD="bgcolor: #FDE9D9"]REID, ERNIE[/TD]
[TD="bgcolor: #FDE9D9"]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
39​
[/TD]
[TD]REID, MARLENE*[/TD]
[TD]
17​
[/TD]
[/TR]
</tbody>[/TABLE]
Not quite, I wanted the total handicap of all 4somes to be as close as possible. It's great that the teams keep the spouses together but like I said the total of the handicaps has to be close. Thanks so much for your effort, if you could make it work so they are close in total that would be awesome.
 
Upvote 0
any example for 5 teams?

edit:
and don't quote whole post, please! use just Reply not Reply With Quote
 
Last edited:
Upvote 0
Not exactly sure what you mean but from doing it by hand I match the teams so that their total handicaps comes to about 50. Of course there are a few couples that are very low ie the Richardsons are a 2 and a 4 so they can only be matched with the highest pair who are a 16 and a 17. There are a few others like that as well ie Lewis, Soczka.
most of the others if equally matched will be around 50. I hope this makes sense. It would be great if each time you hit the push me it would do a different match. I know I am asking a lot, not even sure it is doable.
Thanks, Randy
 
Upvote 0
something like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Index[/td][td=bgcolor:#70AD47]name[/td][td=bgcolor:#70AD47]handicap[/td][td][/td][td]Tot[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
0​
[/td][td=bgcolor:#E2EFDA]MANIS, JOHN*[/td][td=bgcolor:#E2EFDA]
4​
[/td][td][/td][td]
50​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
0​
[/td][td]MANNIS, LINDA*[/td][td]
13​
[/td][td][/td][td]
50​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
0​
[/td][td=bgcolor:#E2EFDA]MILLER, LARAINE[/td][td=bgcolor:#E2EFDA]
17​
[/td][td][/td][td]
50​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
0​
[/td][td]MILLER, DAN[/td][td]
16​
[/td][td][/td][td]
50​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]WILLIAMS, BOB[/td][td=bgcolor:#E2EFDA]
8​
[/td][td][/td][td]
47​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
1​
[/td][td]WILLIAMS, BEVERLY[/td][td]
17​
[/td][td][/td][td]
47​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]COPPO, DON*[/td][td=bgcolor:#E2EFDA]
14​
[/td][td][/td][td]
47​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
1​
[/td][td]COPPO, CHERYL*[/td][td]
8​
[/td][td][/td][td]
47​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]KLIT, EARL*[/td][td=bgcolor:#E2EFDA]
8​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
2​
[/td][td]KLIT, ESTHER*[/td][td]
17​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]MATTSON, LELAND[/td][td=bgcolor:#E2EFDA]
16​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
2​
[/td][td]MATTSON, KATHLEEN[/td][td]
15​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
3​
[/td][td=bgcolor:#E2EFDA]WOOD, LYLE[/td][td=bgcolor:#E2EFDA]
16​
[/td][td][/td][td]
55​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
3​
[/td][td]WOOD, DORTHY[/td][td]
17​
[/td][td][/td][td]
55​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
3​
[/td][td=bgcolor:#E2EFDA]HRABETS, MARY[/td][td=bgcolor:#E2EFDA]
17​
[/td][td][/td][td]
55​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
3​
[/td][td]HRABETS, HERB[/td][td]
5​
[/td][td][/td][td]
55​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
4​
[/td][td=bgcolor:#E2EFDA]DALTON, JACK[/td][td=bgcolor:#E2EFDA]
11​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
4​
[/td][td]DALTON, KAY[/td][td]
17​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
4​
[/td][td=bgcolor:#E2EFDA]UPENIECKS, CAROL[/td][td=bgcolor:#E2EFDA]
13​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
4​
[/td][td]UPENIECKS, EMO[/td][td]
15​
[/td][td][/td][td]
56​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
5​
[/td][td=bgcolor:#E2EFDA]HOLLAND, PAT[/td][td=bgcolor:#E2EFDA]
17​
[/td][td][/td][td]
59​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
5​
[/td][td]HOLLAND, RONALD*[/td][td]
9​
[/td][td][/td][td]
59​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
5​
[/td][td=bgcolor:#E2EFDA]VANBIBBER, WALT[/td][td=bgcolor:#E2EFDA]
16​
[/td][td][/td][td]
59​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
5​
[/td][td]VANBIBBER, CONNIE[/td][td]
17​
[/td][td][/td][td]
59​
[/td][/tr]
[/table]


I'm afraid you'll need vba to do this if Tot should be more close to 50 or even =50
 
Last edited:
Upvote 0
There is existing vba code in the file. When run it makes teams that are very close to 50 but it does not keep the spouses together. Can the code be altered to do that? You have looked at the code, right?
 
Upvote 0
sorry mate but I'm not interested in vba in any form so you'll need to wait for someone else

have a nice day
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,180
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top