3D Barrel Racing Spreadsheet

[Kelley492775]

I need help setting up a spreadsheet that will arrange times, places, and divisions automatically if possible. To explain, each D is different. In a 4D format, The 1D needs to be the quickest time then the 2D is .5 Seconds off the quickest time. The 3D is 1.0 off the quickest time and the 4D is 2.0 off the quickest time. in a 3D format each D is 1.0 second split off the quickest time. Here is an example of the setup of how I manually do it. thanks so much in advanced.

[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl66, width: 39, bgcolor: transparent"]#
[/TD]
[TD="class: xl66, width: 138, bgcolor: transparent"]RIDER'S NAME
[/TD]
[TD="class: xl66, width: 121, bgcolor: transparent"]HORSE'S NAME
[/TD]
[TD="class: xl68, width: 79, bgcolor: transparent"]TIME
[/TD]
[TD="class: xl69, width: 71, bgcolor: transparent"]PLACE
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]DIVISION
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]35
[/TD]
[TD="class: xl67, bgcolor: transparent"]Lacie Brownless
[/TD]
[TD="class: xl67, bgcolor: transparent"]Sister
[/TD]
[TD="class: xl71, bgcolor: yellow"]15.686
[/TD]
[TD="class: xl69, bgcolor: transparent"]1st
[/TD]
[TD="class: xl70, bgcolor: transparent"]1D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]11
[/TD]
[TD="class: xl67, bgcolor: transparent"]Carlie Redfern
[/TD]
[TD="class: xl67, bgcolor: transparent"]Peanut
[/TD]
[TD="class: xl71, bgcolor: yellow"]16.092
[/TD]
[TD="class: xl69, bgcolor: transparent"]2nd
[/TD]
[TD="class: xl70, bgcolor: transparent"]1D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]7
[/TD]
[TD="class: xl67, bgcolor: transparent"]Julie Shaw
[/TD]
[TD="class: xl67, bgcolor: transparent"]Roxy
[/TD]
[TD="class: xl71, bgcolor: yellow"]16.152
[/TD]
[TD="class: xl69, bgcolor: transparent"]3rd
[/TD]
[TD="class: xl70, bgcolor: transparent"]1D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, bgcolor: transparent"]Rainey Booska
[/TD]
[TD="class: xl67, bgcolor: transparent"]Jake
[/TD]
[TD="class: xl71, bgcolor: yellow"]16.157
[/TD]
[TD="class: xl69, bgcolor: transparent"]4th
[/TD]
[TD="class: xl70, bgcolor: transparent"]1D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]37
[/TD]
[TD="class: xl67, bgcolor: transparent"]Elana Marchetti
[/TD]
[TD="class: xl67, bgcolor: transparent"]Cashmere
[/TD]
[TD="class: xl68, bgcolor: transparent"]16.417
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]14
[/TD]
[TD="class: xl67, bgcolor: transparent"]Carlie Cooper
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bug
[/TD]
[TD="class: xl68, bgcolor: transparent"]16.526
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, bgcolor: transparent"]Pam Alderman
[/TD]
[TD="class: xl67, bgcolor: transparent"]Dunie
[/TD]
[TD="class: xl68, bgcolor: transparent"]16.671
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]23
[/TD]
[TD="class: xl67, bgcolor: transparent"]Brittany Osburn
[/TD]
[TD="class: xl67, bgcolor: transparent"]Tango
[/TD]
[TD="class: xl68, bgcolor: transparent"]16.676
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]42
[/TD]
[TD="class: xl67, bgcolor: transparent"]Julie Shaw
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bubba J
[/TD]
[TD="class: xl71, bgcolor: yellow"]16.689
[/TD]
[TD="class: xl69, bgcolor: transparent"]1ST
[/TD]
[TD="class: xl70, bgcolor: transparent"]2D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, bgcolor: transparent"]Laurie Boger
[/TD]
[TD="class: xl67, bgcolor: transparent"]Delta Jet
[/TD]
[TD="class: xl71, bgcolor: yellow"]16.742
[/TD]
[TD="class: xl69, bgcolor: transparent"]2nd
[/TD]
[TD="class: xl70, bgcolor: transparent"]2D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, bgcolor: transparent"]Meghan Artymowycz
[/TD]
[TD="class: xl67, bgcolor: transparent"]Scarlett
[/TD]
[TD="class: xl71, bgcolor: yellow"]16.785
[/TD]
[TD="class: xl69, bgcolor: transparent"]3rd
[/TD]
[TD="class: xl70, bgcolor: transparent"]2D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]32
[/TD]
[TD="class: xl67, bgcolor: transparent"]Donna Lowery
[/TD]
[TD="class: xl67, bgcolor: transparent"]Raisin
[/TD]
[TD="class: xl71, bgcolor: yellow"]16.874
[/TD]
[TD="class: xl69, bgcolor: transparent"]4th
[/TD]
[TD="class: xl70, bgcolor: transparent"]2D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, bgcolor: transparent"]Stacy Marchetti
[/TD]
[TD="class: xl67, bgcolor: transparent"]Felicity
[/TD]
[TD="class: xl68, bgcolor: transparent"]16.879
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]31
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kendall Green
[/TD]
[TD="class: xl67, bgcolor: transparent"]Jetter
[/TD]
[TD="class: xl68, bgcolor: transparent"]17.095
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]28
[/TD]
[TD="class: xl67, bgcolor: transparent"]Melissa Green
[/TD]
[TD="class: xl67, bgcolor: transparent"]Annie
[/TD]
[TD="class: xl68, bgcolor: transparent"]17.223
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]12
[/TD]
[TD="class: xl67, bgcolor: transparent"]Carrie Wilmer
[/TD]
[TD="class: xl67, bgcolor: transparent"]Ruger
[/TD]
[TD="class: xl68, bgcolor: transparent"]17.438
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]36
[/TD]
[TD="class: xl67, bgcolor: transparent"]Taylor Cronk
[/TD]
[TD="class: xl67, bgcolor: transparent"]Katara
[/TD]
[TD="class: xl68, bgcolor: transparent"]17.5
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]8
[/TD]
[TD="class: xl67, bgcolor: transparent"]Brooke Buffkin
[/TD]
[TD="class: xl67, bgcolor: transparent"]Harley
[/TD]
[TD="class: xl68, bgcolor: transparent"]17.65
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]45
[/TD]
[TD="class: xl67, bgcolor: transparent"]Denise Vickers
[/TD]
[TD="class: xl67, bgcolor: transparent"]Harley
[/TD]
[TD="class: xl68, bgcolor: transparent"]17.66
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]29
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kim Redfern
[/TD]
[TD="class: xl67, bgcolor: transparent"]Dash
[/TD]
[TD="class: xl71, bgcolor: yellow"]17.869
[/TD]
[TD="class: xl69, bgcolor: transparent"]1ST
[/TD]
[TD="class: xl70, bgcolor: transparent"]3D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]16
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kat McCaslin
[/TD]
[TD="class: xl67, bgcolor: transparent"]Levi
[/TD]
[TD="class: xl71, bgcolor: yellow"]17.943
[/TD]
[TD="class: xl69, bgcolor: transparent"]2nd
[/TD]
[TD="class: xl70, bgcolor: transparent"]3D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]21
[/TD]
[TD="class: xl67, bgcolor: transparent"]Brittany Shortt
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bailey
[/TD]
[TD="class: xl71, bgcolor: yellow"]17.959
[/TD]
[TD="class: xl69, bgcolor: transparent"]3rd
[/TD]
[TD="class: xl70, bgcolor: transparent"]3D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, bgcolor: transparent"]Caressa Thomas
[/TD]
[TD="class: xl67, bgcolor: transparent"]Rocket
[/TD]
[TD="class: xl71, bgcolor: yellow"]18.002
[/TD]
[TD="class: xl69, bgcolor: transparent"]4th
[/TD]
[TD="class: xl70, bgcolor: transparent"]3D
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]10
[/TD]
[TD="class: xl67, bgcolor: transparent"]April Bratcher
[/TD]
[TD="class: xl67, bgcolor: transparent"]Boo
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.008
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]47
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kayla Kiechle
[/TD]
[TD="class: xl67, bgcolor: transparent"]Urban Tiger
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.219
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]18
[/TD]
[TD="class: xl67, bgcolor: transparent"]Candace Fuller
[/TD]
[TD="class: xl67, bgcolor: transparent"]Moonshine
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.259
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]48
[/TD]
[TD="class: xl67, bgcolor: transparent"]Brooke Buffkin
[/TD]
[TD="class: xl67, bgcolor: transparent"]CJ
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.263
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]41
[/TD]
[TD="class: xl67, bgcolor: transparent"]Eve Santiago
[/TD]
[TD="class: xl67, bgcolor: transparent"]My Lady
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.297
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]5
[/TD]
[TD="class: xl67, bgcolor: transparent"]Taylor Cronk
[/TD]
[TD="class: xl67, bgcolor: transparent"]Toph
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.414
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]43
[/TD]
[TD="class: xl67, bgcolor: transparent"]Darlene Hawk
[/TD]
[TD="class: xl67, bgcolor: transparent"]Rosa
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.496
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]9
[/TD]
[TD="class: xl67, bgcolor: transparent"]Sarah Lapinski
[/TD]
[TD="class: xl67, bgcolor: transparent"]Passion
[/TD]
[TD="class: xl68, bgcolor: transparent"]18.956
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]44
[/TD]
[TD="class: xl67, bgcolor: transparent"]Samantha Williams
[/TD]
[TD="class: xl67, bgcolor: transparent"]Tucker
[/TD]
[TD="class: xl68, bgcolor: transparent"]19.301
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]50
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kat Citta
[/TD]
[TD="class: xl67, bgcolor: transparent"]Major
[/TD]
[TD="class: xl68, bgcolor: transparent"]19.368
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, bgcolor: transparent"]Jenny Parrott
[/TD]
[TD="class: xl67, bgcolor: transparent"]Biscuit
[/TD]
[TD="class: xl68, bgcolor: transparent"]19.944
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]30
[/TD]
[TD="class: xl67, bgcolor: transparent"]Emily Faith Holder
[/TD]
[TD="class: xl67, bgcolor: transparent"]Moxie
[/TD]
[TD="class: xl68, bgcolor: transparent"]20.147
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]13
[/TD]
[TD="class: xl67, bgcolor: transparent"]Missi Crapps
[/TD]
[TD="class: xl67, bgcolor: transparent"]Martini
[/TD]
[TD="class: xl68, bgcolor: transparent"]20.165
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]39
[/TD]
[TD="class: xl67, bgcolor: transparent"]Brittany Darford
[/TD]
[TD="class: xl67, bgcolor: transparent"]Mr No Name
[/TD]
[TD="class: xl68, bgcolor: transparent"]21.004
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]46
[/TD]
[TD="class: xl67, bgcolor: transparent"]Abby Campbell
[/TD]
[TD="class: xl67, bgcolor: transparent"]Bubbles
[/TD]
[TD="class: xl68, bgcolor: transparent"]21.621
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]25
[/TD]
[TD="class: xl67, bgcolor: transparent"]Sage Stovall
[/TD]
[TD="class: xl67, bgcolor: transparent"]Angel
[/TD]
[TD="class: xl68, bgcolor: transparent"]24.237
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]24
[/TD]
[TD="class: xl67, bgcolor: transparent"]Slone Fleckinger
[/TD]
[TD="class: xl67, bgcolor: transparent"]Chancey
[/TD]
[TD="class: xl68, bgcolor: transparent"]25.402
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]15
[/TD]
[TD="class: xl67, bgcolor: transparent"]Alexis Huland
[/TD]
[TD="class: xl67, bgcolor: transparent"]Buster
[/TD]
[TD="class: xl68, bgcolor: transparent"]NT
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]17
[/TD]
[TD="class: xl67, bgcolor: transparent"]Katie Corona
[/TD]
[TD="class: xl67, bgcolor: transparent"]Power Commnder
[/TD]
[TD="class: xl68, bgcolor: transparent"]NT
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]19
[/TD]
[TD="class: xl67, bgcolor: transparent"]Jackie Brockhurst
[/TD]
[TD="class: xl67, bgcolor: transparent"]Razz
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]20
[/TD]
[TD="class: xl67, bgcolor: transparent"]Emily Bevers
[/TD]
[TD="class: xl67, bgcolor: transparent"]Rumor
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]26
[/TD]
[TD="class: xl67, bgcolor: transparent"]Shelby Gromme
[/TD]
[TD="class: xl67, bgcolor: transparent"]Rusty
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]27
[/TD]
[TD="class: xl67, bgcolor: transparent"]Pam Alderman
[/TD]
[TD="class: xl67, bgcolor: transparent"]RJ
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]34
[/TD]
[TD="class: xl67, bgcolor: transparent"]Lexi Woods
[/TD]
[TD="class: xl67, bgcolor: transparent"]Chica
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]38
[/TD]
[TD="class: xl67, bgcolor: transparent"]Kaelynn Hawk
[/TD]
[TD="class: xl67, bgcolor: transparent"]Luna
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]40
[/TD]
[TD="class: xl67, bgcolor: transparent"]Michelle Cartwright
[/TD]
[TD="class: xl67, bgcolor: transparent"]Jessie
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]49
[/TD]
[TD="class: xl67, bgcolor: transparent"]KAMERON Laube
[/TD]
[TD="class: xl67, bgcolor: transparent"]Slammer
[/TD]
[TD="class: xl68, bgcolor: transparent"]nt
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[stunnrock]

For 3D, try this in E2:

=IF(((E1="PLACE")+(E1=""))*(RIGHT($F2,1)="D"),"1st",IF(E1="","",INDEX({"2nd";"3rd";"4th";""},LEFT(E1,1))))

In F2:

=IF(COUNTIF(F1:F$1,"1D")<4,"1D",IF(($D2>$D$2+1)*(COUNTIF(F1:F$2,"2D")<4),"2D",IF(($D2>$D$2+2)*(COUNTIF(F1:F$2,"3D")<4),"3D","")))

Copy them down as far as required.

I'll leave you to work out the 4D.

 

[Kelley492775]

ok I copies and pasted that and its throwing me a little arrow sign and says #value in the E column and just the symbol in the F Column. lol im dumb I guess.

For 3D, try this in E2:

=IF(((E1="PLACE")+(E1=""))*(RIGHT($F2,1)="D"),"1st",IF(E1="","",INDEX({"2nd";"3rd";"4th";""},LEFT(E1,1))))

In F2:

=IF(COUNTIF(F1:F$1,"1D")<4,"1D",IF(($D2>$D$2+1)*(COUNTIF(F1:F$2,"2D")<4),"2D",IF(($D2>$D$2+2)*(COUNTIF(F1:F$2,"3D")<4),"3D","")))

Copy them down as far as required.

I'll leave you to work out the 4D.

 

[stunnrock]

Improvement for E2:

=IF(OR((E1="")*(RIGHT($F2,1)="D"),$D2=$D$2),"1st",IF(E1="","",INDEX({"2nd";"3rd";"4th";""},LEFT(E1,1))))

 

[stunnrock]

Does your table start in A1?

 

[Kelley492775]

Ok i got it. How would you do .5 second splits inastead of 1.0 second splits?

 

[stunnrock]

Where the second formula has $D$2+1 and $D$2+2, you would change them to $D$2+.5 and $D$2+1 respectively.

 

[Kelley492775]

ok so I got it to be a 4D format, but please look a E11. It should be 1st in the 3D but its starting on E12 but the F column is correct with the 16.862 starting the 3d. Can you help please

[TABLE="width: 629"]
<tbody>[TR]
[TD]#[/TD]
[TD]RIDER'S NAME[/TD]
[TD]HORSE'S NAME[/TD]
[TD]OPEN[/TD]
[TD]PLACE[/TD]
[TD]Division[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Diamond Scharfenstine[/TD]
[TD]GL Dashing Blonde[/TD]
[TD]15.854[/TD]
[TD]1st[/TD]
[TD]1D[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Elizabeth Bradin[/TD]
[TD]Smoke[/TD]
[TD]16.027[/TD]
[TD]2nd[/TD]
[TD]1D[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]Angela Mack[/TD]
[TD]Sweetie[/TD]
[TD]16.106[/TD]
[TD]3rd[/TD]
[TD]1D[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Julie Shaw[/TD]
[TD]Bubba[/TD]
[TD]16.121[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Jason Tibbs[/TD]
[TD]Bonita Blitz[/TD]
[TD]16.177[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Elana Marchetti[/TD]
[TD]Cashmere[/TD]
[TD]16.309[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]Soleil Byrtus[/TD]
[TD]Jett[/TD]
[TD]16.64[/TD]
[TD]1st[/TD]
[TD]2D[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Barbara Calhoun[/TD]
[TD]Zac[/TD]
[TD]16.683[/TD]
[TD]2nd[/TD]
[TD]2D[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Brittanee Worden[/TD]
[TD]Atlantis[/TD]
[TD]16.747[/TD]
[TD]3rd[/TD]
[TD]2D[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Brandie Harrell[/TD]
[TD]Sky Scapper[/TD]
[TD]16.862[/TD]
[TD][/TD]
[TD]3D[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Pam Alderman[/TD]
[TD]Dunie[/TD]
[TD]16.889[/TD]
[TD]1st[/TD]
[TD]3D[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]Lillie Desimone[/TD]
[TD]Stetson[/TD]
[TD]16.893[/TD]
[TD]2nd[/TD]
[TD]3D[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]Brittanee Worden[/TD]
[TD]Whiteout[/TD]
[TD]17.129[/TD]
[TD]3rd[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]Kady Rittmanic[/TD]
[TD]Legend[/TD]
[TD]17.179[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]Kendall Worden[/TD]
[TD]Taffy[/TD]
[TD]17.249[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Diamond Scharfenstine[/TD]
[TD]Missy's Sun Drift[/TD]
[TD]17.251[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]Emily Bevers[/TD]
[TD]Rumor Has It[/TD]
[TD]17.324[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]Brandie Harrell[/TD]
[TD]Easily A Free Runner[/TD]
[TD]17.351[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]Ricki Godsey[/TD]
[TD]Queen Bee[/TD]
[TD]17.371[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]Candace Fuller[/TD]
[TD]Moonshine[/TD]
[TD]17.427[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]Vera Byrtus[/TD]
[TD]Jake[/TD]
[TD]17.652[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]Dawn Wilborn[/TD]
[TD]Docs Easy Stick[/TD]
[TD]17.739[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Hollie Dowling[/TD]
[TD]Hollywood[/TD]
[TD]17.749[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Kat McCaslin[/TD]
[TD]Piper[/TD]
[TD]17.826[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Meghan Artymowycz[/TD]
[TD]Shy[/TD]
[TD]17.892[/TD]
[TD]1st[/TD]
[TD]4D[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]Morgan Mathusa[/TD]
[TD]Fuze[/TD]
[TD]18.044[/TD]
[TD]2nd[/TD]
[TD]4D[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]Kristal Farrell[/TD]
[TD]Hallie[/TD]
[TD]18.12[/TD]
[TD]3rd[/TD]
[TD]4D[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]Sarah Capinski[/TD]
[TD]Fancy[/TD]
[TD]19.078[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Chelsey Bash[/TD]
[TD]Dash[/TD]
[TD]19.169[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD]Shayne Hilton[/TD]
[TD]Flick[/TD]
[TD]19.217[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]Jessica Vancil[/TD]
[TD]Cody[/TD]
[TD]19.479[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD]Christina Sylvester[/TD]
[TD]Dixie[/TD]
[TD]19.497[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]Sage Stovall[/TD]
[TD]Nellie[/TD]
[TD]23.768[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]Tiffany Jenkins[/TD]
[TD]Kody[/TD]
[TD]27.599[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Katrina DeVuyst (Devust)[/TD]
[TD]Ceary[/TD]
[TD]NT[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Ally Marchetti[/TD]
[TD]Comeback Kid[/TD]
[TD]NT[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]Jessica Knowles[/TD]
[TD]Brownie[/TD]
[TD]NT[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]Hollie Dowling[/TD]
[TD]Romeo[/TD]
[TD]NT[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]Dallas Kelley[/TD]
[TD]Hank[/TD]
[TD]NT[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]DRAW OUT[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]Kat McCaslin[/TD]
[TD]Drifter[/TD]
[TD]21.732[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col span="2"><col><col><col></colgroup>[/TABLE]

 

[Kelley492775]

Sorry if this is a repeat but in the reply above I cant see my message just the spreadsheet. I need help with 16.862 line. That time should be 1st in the 3D, but its saying the time under is 1st,. how do I change that?

 

[stunnrock]

That needed a bit of a rethink:

In E2, then copied downward:

=IF(RIGHT($F2,1)="D",INDEX({"1st";"2nd";"3rd"},COUNTIF(INDEX($F:$F,MAX(2,ROW()-2)):$F2,$F2)),"")