SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,144
- Office Version
- 2019
- 2016
- Platform
- 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]
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]