formula help on a sheet

S

SQUIDD

Well-known Member
Joined
Jan 2, 2009
Messages
2,144
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hi All

I have data in a sheet in column A and column B.
I want to end up filtering column C dependant on if it has a "1"

Column A looks like this.

A2=07:20
A3=Grade: A9 Prize: £62 Distance: 470m Going: -170
A4=http://www.site/dog_home.sd?dog_id=1
A5=http://www.site/dog_home.sd?dog_id=6
A6=http://www.site/dog_home.sd?dog_id=4
A7=http://www.site/dog_home.sd?dog_id=12
A8=http://www.site/dog_home.sd?dog_id=100
A9=http://www.site/dog_home.sd?dog_id=29

Then it repeats as above with another batch of data similar. Generally the data is 8 lines long, but sometimes not, that is MY PROBLEM.I want to filter the data that had all 6 runners. So in the example above c2,c3,c3,c4,c5,c6,c7,c8,c9 would ="1".
But in the example below c2,c3,c3,c4,c5,c6,c7,c8 would =""

A2=07:20
A3=Grade: A9 Prize: £62 Distance: 470m Going: -170
A4=http://www.site/dog_home.sd?dog_id=1
A5=http://www.site/dog_home.sd?dog_id=6
A6=http://www.site/dog_home.sd?dog_id=4
A7=http://www.site/dog_home.sd?dog_id=12
A8=http://www.site/dog_home.sd?dog_id=100

If it helps column B looks like this.

[TABLE="width: 309"]
<tbody>[TR]
[TD]B2=07:20
B3=Grade: A9 Prize: £62
B4=Hawaiian Flash[/TD]
[/TR]
[TR]
[TD]B5=Smooth Lane[/TD]
[/TR]
[TR]
[TD]B6=Under The Limit[/TD]
[/TR]
[TR]
[TD]B7=Whitelaithelady[/TD]
[/TR]
[TR]
[TD]B8=Drumsna Lucy[/TD]
[/TR]
[TR]
[TD]B9=Birkdale Lass

The whole thing is to do with is there blocks of 8 and if they are part of the block of 8 I want to filter and keep and if not filter out before a copy and paste.

Thanks for looking.

Dave
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
 
Sort by date Sort by votes
Just adding more info.

This is my data and how I want column C to look.

[TABLE="width: 674"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
Code: 
[TR]
[TD="align: right"]07:20[/TD]
[TD="align: right"]07:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A9 Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A9 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][URL="http://www.racingpost.com/greyhounds/dog_home.sd?dog_id=85378"]http:/SITE/dog_home.sd?dog_id=85378[/URL][/TD]
[TD]Hawaiian Flash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=329394[/TD]
[TD]Smooth Lane[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=78892[/TD]
[TD]Under The Limit[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=342242[/TD]
[TD]Whitelaithelady[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=329557[/TD]
[TD]Drumsna Lucy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385601[/TD]
[TD]Birkdale Lass[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]07:35[/TD]
[TD="align: right"]07:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A7 Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A7 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=312653[/TD]
[TD]Vatican Huggie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=84206[/TD]
[TD]Oak Ridge[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386395[/TD]
[TD]Afflecks Palace[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382965[/TD]
[TD]Grandmasterflash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=361524[/TD]
[TD]Catsrock Laura[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385722[/TD]
[TD]Telmarcs Black[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]07:50[/TD]
[TD="align: right"]07:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A8 Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A8 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=381036[/TD]
[TD]Highview Dawn[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=359334[/TD]
[TD]Emerson Trixie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=351405[/TD]
[TD]Cool Dee[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=304968[/TD]
[TD]False Alarm[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=377440[/TD]
[TD]Niamhs Playboy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=383035[/TD]
[TD]Blackrock Rosie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:05[/TD]
[TD="align: right"]08:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -170[/TD]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373693[/TD]
[TD]Grandads Jet[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=350138[/TD]
[TD]Emerson Brock[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=331969[/TD]
[TD]Count Dontez[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=345344[/TD]
[TD]Highview Leader[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=371993[/TD]
[TD]Noirs Doll[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=318440[/TD]
[TD]Bluetooth Bruce[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:20[/TD]
[TD="align: right"]08:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=356822[/TD]
[TD]Noirs Terry[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=346002[/TD]
[TD]Canaska Cando[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=346915[/TD]
[TD]Dylan Stamper[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378022[/TD]
[TD]Coolavanny Perch[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=356430[/TD]
[TD]Ballinure Duke[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=357936[/TD]
[TD]Lulus Pet[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:35[/TD]
[TD="align: right"]08:35[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Grade: A1 Prize: £186 Distance: 470m Going: -170[/TD]
[TD]Grade: A1 Prize: £186 Distance: 470m Going: -170[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=352494[/TD]
[TD]Marsh Brook Sam[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=368147[/TD]
[TD]Rocket Kane[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=369401[/TD]
[TD]Classic Scolari[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=365433[/TD]
[TD]Pinehill Star[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=376539[/TD]
[TD]Swords Tosh[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]08:50[/TD]
[TD="align: right"]08:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A4 Prize: £146 Distance: 470m Going: -170[/TD]
[TD]Grade: A4 Prize: £146 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=372655[/TD]
[TD]Out Of Town[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=360898[/TD]
[TD]Toll Prince[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385060[/TD]
[TD]Delwood Gold[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378935[/TD]
[TD]Guinness[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=324128[/TD]
[TD]Freedom Hope[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382000[/TD]
[TD]Mottee Invader[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:05[/TD]
[TD="align: right"]09:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=316443[/TD]
[TD]Mercury Amaru[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373596[/TD]
[TD]Droopys Pippa[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=337838[/TD]
[TD]Copeland Rocket[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=362540[/TD]
[TD]King Romanov[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=375998[/TD]
[TD]Knockrour Tapped[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=348844[/TD]
[TD]Noirs Tina[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:20[/TD]
[TD="align: right"]09:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A3 Prize: £151 Distance: 470m Going: -170[/TD]
[TD]Grade: A3 Prize: £151 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=374304[/TD]
[TD]Freckleton[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373364[/TD]
[TD]Deal The River[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=379458[/TD]
[TD]Beckstone Carys[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=371143[/TD]
[TD]Heavenly Chris[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=365487[/TD]
[TD]Boozed Causeway[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=345063[/TD]
[TD]Iron White Tyson[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:35[/TD]
[TD="align: right"]09:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A6 Prize: £62 Distance: 470m Going: -160[/TD]
[TD]Grade: A6 Prize: £62 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325157[/TD]
[TD]Rusty Snail[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385721[/TD]
[TD]Driven Snow[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=331612[/TD]
[TD]Kilglass Cara[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=309391[/TD]
[TD]Double Mission[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378937[/TD]
[TD]Pinsleysandstorm[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386391[/TD]
[TD]Precious Tees[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:50[/TD]
[TD="align: right"]09:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A4 Prize: £72 Distance: 470m Going: -160[/TD]
[TD]Grade: A4 Prize: £72 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386394[/TD]
[TD]Smithstown Jack[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382687[/TD]
[TD]Dickybo Den[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386392[/TD]
[TD]Doon Maeve[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=348245[/TD]
[TD]Tesoro Mio[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378926[/TD]
[TD]Paid By Cash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385599[/TD]
[TD]Rathclough[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:05[/TD]
[TD="align: right"]10:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A3 Prize: £77 Distance: 470m Going: -160[/TD]
[TD]Grade: A3 Prize: £77 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=384025[/TD]
[TD]Boomtown Playboy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=372370[/TD]
[TD]Lively Twist[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=379298[/TD]
[TD]Fringe Benefit[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=350411[/TD]
[TD]Clubbing Night[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=376653[/TD]
[TD]Uncle Seanie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=384030[/TD]
[TD]The Dandler[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:20[/TD]
[TD="align: right"]10:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -160[/TD]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373692[/TD]
[TD]Grandads Ebony[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385600[/TD]
[TD]Telmarcs Hondo[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325872[/TD]
[TD]Greylag Paris[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=352868[/TD]
[TD]Amarillo Star[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=380947[/TD]
[TD]Tullymurry Year[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325551[/TD]
[TD]Whinmoor Molly[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:35[/TD]
[TD="align: right"]10:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £82 Distance: 470m Going: -160[/TD]
[TD]Grade: A2 Prize: £82 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=309542[/TD]
[TD]Delwood Token[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=339389[/TD]
[TD]Cortaflex Purity[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=315236[/TD]
[TD]Rei Doms Ronaldo[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=354749[/TD]
[TD]Gulf Express[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=337196[/TD]
[TD]Romeo Hurricane[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=361482[/TD]
[TD]Vote For Pedro[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody><colgroup><col span="2"><col></colgroup>[/TABLE]
<strike></strike>
 
Upvote 0

Book1
ABCDE
1
207:20
3Grade: A9 Prize: £62 Distance: 470m Going: -170ok$B$4:$B$10
4http://www.site/dog_home.sd?dog_id1
5http://www.site/dog_home.sd?dog_id6
6http://www.site/dog_home.sd?dog_id4
7http://www.site/dog_home.sd?dog_id12
8http://www.site/dog_home.sd?dog_id100
9http://www.site/dog_home.sd?dog_id29
1007:20
11Grade: A9 Prize: £62 Distance: 470m Going: -170failure$B$12:$B$18
12http://www.site/dog_home.sd?dog_id1
13http://www.site/dog_home.sd?dog_id6
14http://www.site/dog_home.sd?dog_id4
15http://www.site/dog_home.sd?dog_id12
16http://www.site/dog_home.sd?dog_id100
Blad22
Cell Formulas
RangeFormula
D3=IFERROR(IF(AND(LEFT($A3,5)="Grade",COUNTIF(INDIRECT($E3),">0")=6),"ok","failure"),"")
E3=IF(LEFT(A3,5)="grade",ADDRESS(ROW()+1,2)&":"&ADDRESS(ROW()+7,2),"")
 
Upvote 0
Hi oeldere

Thanks for looking, mine show failures in all.
But also, I don't think I explained very well, but I want a 1 in each row the block of 8 are ok, so I can filter out the data I don't want before copy.

cheers

dave
 
Upvote 0
Is a macro solution acceptable to you? If so...
Code: 
[table="width: 500"]
[tr]
	[td]Sub SixRunners()
  Dim NonTimeData As Range
  Columns("C").ClearContents
  For Each NonTimeData In Columns("A").SpecialCells(xlConstants, xlTextValues).Areas
    If NonTimeData.Rows.Count = 7 Then NonTimeData.Offset(-1, 2).Resize(NonTimeData.Count + 1).Value = 1
  Next
End Sub[/td]
[/tr]
[/table]
 
Last edited:
Upvote 0
Rick

You are a true genius. I see you on here, I don't think you miss anything and always understand what people want.
A macro is actually a neater option here in any case.
Thank you very much.

Tested it and it works of course.

Thanks again rick.
 
Upvote 0
Hi Rick

Would we also be able to not put a 1 in column C if column A, the 2nd row of the block of 8 did not contain "Grade: A".
This was something else I was doing additionally with formula previously.

Many thanks

Dave
 
Upvote 0
SQUIDD said:
Hi Rick

Would we also be able to not put a 1 in column C if column A, the 2nd row of the block of 8 did not contain "Grade: A".
This was something else I was doing additionally with formula previously.
Click to expand...
I hate double-negatives as they make the intent somewhat unclear. Perhaps if you posted example data with whatever condition you are trying to describe (like you did in Message #2), then I can see exactly what you are attempting to do and write the code for what I see as opposed to what I attempt to interpret from your description.
 
Upvote 0
Hi Rick

The data remains the same except, sometimes it the Grade does not start with an A.
Please seen below in block 2 and 4 of the 8. Where I have changed it to OR and H1.
So these blocks also will not require the "1" in column C
I thank you for your time in advance
Code: 
[TABLE="class: cms_table, width: 674"]
<tbody>[TR]
[TD="align: right"]07:20[/TD]
[TD="align: right"]07:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A9 Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A9 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][URL="http://www.racingpost.com/greyhounds/dog_home.sd?dog_id=85378"]http:/SITE/dog_home.sd?dog_id=85378[/URL][/TD]
[TD]Hawaiian Flash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=329394[/TD]
[TD]Smooth Lane[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=78892[/TD]
[TD]Under The Limit[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=342242[/TD]
[TD]Whitelaithelady[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=329557[/TD]
[TD]Drumsna Lucy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385601[/TD]
[TD]Birkdale Lass[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]07:35[/TD]
[TD="align: right"]07:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: OR Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A7 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=312653[/TD]
[TD]Vatican Huggie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=84206[/TD]
[TD]Oak Ridge[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386395[/TD]
[TD]Afflecks Palace[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382965[/TD]
[TD]Grandmasterflash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=361524[/TD]
[TD]Catsrock Laura[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385722[/TD]
[TD]Telmarcs Black[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]07:50[/TD]
[TD="align: right"]07:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A8 Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A8 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=381036[/TD]
[TD]Highview Dawn[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=359334[/TD]
[TD]Emerson Trixie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=351405[/TD]
[TD]Cool Dee[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=304968[/TD]
[TD]False Alarm[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=377440[/TD]
[TD]Niamhs Playboy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=383035[/TD]
[TD]Blackrock Rosie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:05[/TD]
[TD="align: right"]08:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: H1 Prize: £67 Distance: 470m Going: -170[/TD]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373693[/TD]
[TD]Grandads Jet[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=350138[/TD]
[TD]Emerson Brock[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=331969[/TD]
[TD]Count Dontez[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=345344[/TD]
[TD]Highview Leader[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=371993[/TD]
[TD]Noirs Doll[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=318440[/TD]
[TD]Bluetooth Bruce[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:20[/TD]
[TD="align: right"]08:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=356822[/TD]
[TD]Noirs Terry[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=346002[/TD]
[TD]Canaska Cando[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=346915[/TD]
[TD]Dylan Stamper[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378022[/TD]
[TD]Coolavanny Perch[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=356430[/TD]
[TD]Ballinure Duke[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=357936[/TD]
[TD]Lulus Pet[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:35[/TD]
[TD="align: right"]08:35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grade: A1 Prize: £186 Distance: 470m Going: -170[/TD]
[TD]Grade: A1 Prize: £186 Distance: 470m Going: -170[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=352494[/TD]
[TD]Marsh Brook Sam[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=368147[/TD]
[TD]Rocket Kane[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=369401[/TD]
[TD]Classic Scolari[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=365433[/TD]
[TD]Pinehill Star[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=376539[/TD]
[TD]Swords Tosh[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]08:50[/TD]
[TD="align: right"]08:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A4 Prize: £146 Distance: 470m Going: -170[/TD]
[TD]Grade: A4 Prize: £146 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=372655[/TD]
[TD]Out Of Town[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=360898[/TD]
[TD]Toll Prince[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385060[/TD]
[TD]Delwood Gold[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378935[/TD]
[TD]Guinness[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=324128[/TD]
[TD]Freedom Hope[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382000[/TD]
[TD]Mottee Invader[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:05[/TD]
[TD="align: right"]09:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=316443[/TD]
[TD]Mercury Amaru[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373596[/TD]
[TD]Droopys Pippa[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=337838[/TD]
[TD]Copeland Rocket[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=362540[/TD]
[TD]King Romanov[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=375998[/TD]
[TD]Knockrour Tapped[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=348844[/TD]
[TD]Noirs Tina[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:20[/TD]
[TD="align: right"]09:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A3 Prize: £151 Distance: 470m Going: -170[/TD]
[TD]Grade: A3 Prize: £151 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=374304[/TD]
[TD]Freckleton[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373364[/TD]
[TD]Deal The River[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=379458[/TD]
[TD]Beckstone Carys[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=371143[/TD]
[TD]Heavenly Chris[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=365487[/TD]
[TD]Boozed Causeway[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=345063[/TD]
[TD]Iron White Tyson[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:35[/TD]
[TD="align: right"]09:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A6 Prize: £62 Distance: 470m Going: -160[/TD]
[TD]Grade: A6 Prize: £62 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325157[/TD]
[TD]Rusty Snail[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385721[/TD]
[TD]Driven Snow[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=331612[/TD]
[TD]Kilglass Cara[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=309391[/TD]
[TD]Double Mission[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378937[/TD]
[TD]Pinsleysandstorm[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386391[/TD]
[TD]Precious Tees[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:50[/TD]
[TD="align: right"]09:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A4 Prize: £72 Distance: 470m Going: -160[/TD]
[TD]Grade: A4 Prize: £72 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386394[/TD]
[TD]Smithstown Jack[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382687[/TD]
[TD]Dickybo Den[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386392[/TD]
[TD]Doon Maeve[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=348245[/TD]
[TD]Tesoro Mio[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378926[/TD]
[TD]Paid By Cash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385599[/TD]
[TD]Rathclough[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:05[/TD]
[TD="align: right"]10:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A3 Prize: £77 Distance: 470m Going: -160[/TD]
[TD]Grade: A3 Prize: £77 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=384025[/TD]
[TD]Boomtown Playboy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=372370[/TD]
[TD]Lively Twist[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=379298[/TD]
[TD]Fringe Benefit[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=350411[/TD]
[TD]Clubbing Night[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=376653[/TD]
[TD]Uncle Seanie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=384030[/TD]
[TD]The Dandler[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:20[/TD]
[TD="align: right"]10:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -160[/TD]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373692[/TD]
[TD]Grandads Ebony[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385600[/TD]
[TD]Telmarcs Hondo[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325872[/TD]
[TD]Greylag Paris[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=352868[/TD]
[TD]Amarillo Star[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=380947[/TD]
[TD]Tullymurry Year[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325551[/TD]
[TD]Whinmoor Molly[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:35[/TD]
[TD="align: right"]10:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £82 Distance: 470m Going: -160[/TD]
[TD]Grade: A2 Prize: £82 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=309542[/TD]
[TD]Delwood Token[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=339389[/TD]
[TD]Cortaflex Purity[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=315236[/TD]
[TD]Rei Doms Ronaldo[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=354749[/TD]
[TD]Gulf Express[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=337196[/TD]
[TD]Romeo Hurricane[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=361482[/TD]
[TD]Vote For Pedro[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
sorry, forgot to change column C, please see re-post
Code: 
[TABLE="class: cms_table, width: 674"]
<tbody>[TR]
[TD="align: right"]07:20[/TD]
[TD="align: right"]07:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A9 Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A9 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][URL="http://www.racingpost.com/greyhounds/dog_home.sd?dog_id=85378"]http:/SITE/dog_home.sd?dog_id=85378[/URL][/TD]
[TD]Hawaiian Flash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=329394[/TD]
[TD]Smooth Lane[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=78892[/TD]
[TD]Under The Limit[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=342242[/TD]
[TD]Whitelaithelady[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=329557[/TD]
[TD]Drumsna Lucy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385601[/TD]
[TD]Birkdale Lass[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]07:35[/TD]
[TD="align: right"]07:35[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Grade: OR Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A7 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=312653[/TD]
[TD]Vatican Huggie[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=84206[/TD]
[TD]Oak Ridge[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386395[/TD]
[TD]Afflecks Palace[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382965[/TD]
[TD]Grandmasterflash[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=361524[/TD]
[TD]Catsrock Laura[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385722[/TD]
[TD]Telmarcs Black[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]07:50[/TD]
[TD="align: right"]07:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A8 Prize: £62 Distance: 470m Going: -170[/TD]
[TD]Grade: A8 Prize: £62 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=381036[/TD]
[TD]Highview Dawn[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=359334[/TD]
[TD]Emerson Trixie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=351405[/TD]
[TD]Cool Dee[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=304968[/TD]
[TD]False Alarm[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=377440[/TD]
[TD]Niamhs Playboy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=383035[/TD]
[TD]Blackrock Rosie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:05[/TD]
[TD="align: right"]08:05[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Grade: H1 Prize: £67 Distance: 470m Going: -170[/TD]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -170[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373693[/TD]
[TD]Grandads Jet[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=350138[/TD]
[TD]Emerson Brock[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=331969[/TD]
[TD]Count Dontez[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=345344[/TD]
[TD]Highview Leader[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=371993[/TD]
[TD]Noirs Doll[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=318440[/TD]
[TD]Bluetooth Bruce[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]08:20[/TD]
[TD="align: right"]08:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=356822[/TD]
[TD]Noirs Terry[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=346002[/TD]
[TD]Canaska Cando[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=346915[/TD]
[TD]Dylan Stamper[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378022[/TD]
[TD]Coolavanny Perch[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=356430[/TD]
[TD]Ballinure Duke[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=357936[/TD]
[TD]Lulus Pet[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]08:35[/TD]
[TD="align: right"]08:35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grade: A1 Prize: £186 Distance: 470m Going: -170[/TD]
[TD]Grade: A1 Prize: £186 Distance: 470m Going: -170[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=352494[/TD]
[TD]Marsh Brook Sam[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=368147[/TD]
[TD]Rocket Kane[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=369401[/TD]
[TD]Classic Scolari[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=365433[/TD]
[TD]Pinehill Star[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=376539[/TD]
[TD]Swords Tosh[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]08:50[/TD]
[TD="align: right"]08:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A4 Prize: £146 Distance: 470m Going: -170[/TD]
[TD]Grade: A4 Prize: £146 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=372655[/TD]
[TD]Out Of Town[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=360898[/TD]
[TD]Toll Prince[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385060[/TD]
[TD]Delwood Gold[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378935[/TD]
[TD]Guinness[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=324128[/TD]
[TD]Freedom Hope[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382000[/TD]
[TD]Mottee Invader[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:05[/TD]
[TD="align: right"]09:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD]Grade: A2 Prize: £156 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=316443[/TD]
[TD]Mercury Amaru[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373596[/TD]
[TD]Droopys Pippa[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=337838[/TD]
[TD]Copeland Rocket[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=362540[/TD]
[TD]King Romanov[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=375998[/TD]
[TD]Knockrour Tapped[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=348844[/TD]
[TD]Noirs Tina[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:20[/TD]
[TD="align: right"]09:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A3 Prize: £151 Distance: 470m Going: -170[/TD]
[TD]Grade: A3 Prize: £151 Distance: 470m Going: -170[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=374304[/TD]
[TD]Freckleton[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373364[/TD]
[TD]Deal The River[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=379458[/TD]
[TD]Beckstone Carys[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=371143[/TD]
[TD]Heavenly Chris[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=365487[/TD]
[TD]Boozed Causeway[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=345063[/TD]
[TD]Iron White Tyson[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:35[/TD]
[TD="align: right"]09:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A6 Prize: £62 Distance: 470m Going: -160[/TD]
[TD]Grade: A6 Prize: £62 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325157[/TD]
[TD]Rusty Snail[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385721[/TD]
[TD]Driven Snow[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=331612[/TD]
[TD]Kilglass Cara[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=309391[/TD]
[TD]Double Mission[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378937[/TD]
[TD]Pinsleysandstorm[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386391[/TD]
[TD]Precious Tees[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]09:50[/TD]
[TD="align: right"]09:50[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A4 Prize: £72 Distance: 470m Going: -160[/TD]
[TD]Grade: A4 Prize: £72 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386394[/TD]
[TD]Smithstown Jack[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=382687[/TD]
[TD]Dickybo Den[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=386392[/TD]
[TD]Doon Maeve[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=348245[/TD]
[TD]Tesoro Mio[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=378926[/TD]
[TD]Paid By Cash[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385599[/TD]
[TD]Rathclough[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:05[/TD]
[TD="align: right"]10:05[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A3 Prize: £77 Distance: 470m Going: -160[/TD]
[TD]Grade: A3 Prize: £77 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=384025[/TD]
[TD]Boomtown Playboy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=372370[/TD]
[TD]Lively Twist[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=379298[/TD]
[TD]Fringe Benefit[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=350411[/TD]
[TD]Clubbing Night[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=376653[/TD]
[TD]Uncle Seanie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=384030[/TD]
[TD]The Dandler[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:20[/TD]
[TD="align: right"]10:20[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -160[/TD]
[TD]Grade: A5 Prize: £67 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=373692[/TD]
[TD]Grandads Ebony[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=385600[/TD]
[TD]Telmarcs Hondo[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325872[/TD]
[TD]Greylag Paris[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=352868[/TD]
[TD]Amarillo Star[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=380947[/TD]
[TD]Tullymurry Year[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=325551[/TD]
[TD]Whinmoor Molly[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10:35[/TD]
[TD="align: right"]10:35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grade: A2 Prize: £82 Distance: 470m Going: -160[/TD]
[TD]Grade: A2 Prize: £82 Distance: 470m Going: -160[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=309542[/TD]
[TD]Delwood Token[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=339389[/TD]
[TD]Cortaflex Purity[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=315236[/TD]
[TD]Rei Doms Ronaldo[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=354749[/TD]
[TD]Gulf Express[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=337196[/TD]
[TD]Romeo Hurricane[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]http:/SITE/dog_home.sd?dog_id=361482[/TD]
[TD]Vote For Pedro[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Add together figures for Year-To-Date (with criteria)
Replies
3
Views
250
Tetra201
Tetra201
E
  • Solved
Ranking Invoices By Highest Amount By "Year to Date"
Replies
2
Views
201
ellison
E
L
  • Question Question
Help with formula to keep leading zero in cell - cant format as date
Replies
4
Views
185
6StringJazzer
6StringJazzer
D
  • Solved
New formula for cumulative values
Replies
6
Views
268
djclements
djclements
S
  • Question Question
Need Help - Formula
2
Replies
16
Views
2K
ststern45
S

Share this page

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