Messages

I've got a fairly complex spreadsheet and trying to count certain things....
If column B contains certain txt, I want to count the no of values in Col X minus the no of cells containing certain words.

I've tried.....

=IF($B:$B="Sample text",(COUNTA(QM$14:QM$213)-COUNTIF(QM$14:QM$213,"FOA")-COUNTIF(QM$14:QM$213,"FOP")-COUNTIF(QM$14:QM$213,"AL")-COUNTIF(QM$14:QM$213,"CL")-COUNTIF(QM$14:QM$213,"S")-COUNTIF(QM$14:QM$213,"T")),"")

Does anyone in Ireland ever uses chains on the tires? Can you even get them?

Think theyre illegal, arent they?

White christmas in dublin is 3/1. might have a flutter on this.

What constitutes a white Christmas? Is it not something like 100mm of sniow at Dublin Airport?

The Mayo News have announced their Club Stars panel, I'm pretty sure this was a public vote (I know the POTY was).

Congrats to Richie Feeney who won POTY, Brendan Prendergast of Tourmack for Intermediate POTY, James Horan for Manager of the Year and our own Ian Rowland who made the team.

Details here:
http://www.sportsmanager.ie/cake/gaa2/mayo/news/27603/Castlebar_s_Richie_Feeney_scoops_Club_Stars_Player_of_the_Year

245 all out with Morgan making a brief appearance!

Aussies 236 for 8 now on what was supposed to be a batsmans pitch!

who puts the card in your door? i'm off this week may i could give them a few slaps or if they're to big let out the dog

Nobody. Check the link in the previous post!

Congrats to Brigids on a fine Connacht Championship run.

Any truth in the rumour that a certain D Blaine is returning for a shot at an All Ireland? I hear he's fighting fit down under - ya wouldnt know the man!!!

So I gave $5 for a poppy today. I didn't take one - am I still ok to post here/still an Irish man???

I dont think Canadian forces killed too many in Ireland so I'd say you're alright.

So is it OK to support Canadian forces if you're in the UK?
Is it an issue because money raised from these sales goes to the British army?
Is it then OK to wear a poppy provided you didnt pay for it?
Assuming (dangerously so) yes to these questions, surely there wouldnt be a problem with people on the tv wearing poppies, that surely they dont pay for???

[she has a savage arse and even while arguing I couldn't take my eyes of it]

Well just back from the pub and near the end myself and my Unionist friend had a bit of a fall out over her poppy. I said nothing all night until one of my English mates pointed out it attached to her bag and that O ***** won't have liked that. She asked me what my problem was with supporting "our boys" and "their sacrifice" it got pretty heated and only ended well coz I agreed to disagree coz she has a savage arse and even while arguing I couldn't take my eyes of it and I really think I have a chance bar the fact that she thinks I'm a raving Provo, which most lads here will think absurd 

Well played, get  priorities straight....savage arse or high ground....arse everyday

Hang on,, how were ya looking at her arse while ya were arguing?! Was she looking over shoulder or something?

Been away for a while, but saddened to hear the death of a young man.

RIP

Used it way back when.... what's the problem?

I've often kicked frees from further out, against the wind and up a hill.

Yes but how wide were they?

How wide can a point be   

Terrible, terrible news.

My sympathy to both families

Looks like the Irish should have a great chance of winning with the weak squad announced by the Aussie's

Weak squad? Are you serious? IMO this is one of the best Aussie squads thats been picked in years.

They've gone and picked players that are suited to the game rather than just the big names - mobile, hard runners.

The likes of Jonny Brown - one of the greatest AFL players around - wouldnt be suited to the International Rules, but Adam Goodes, Brad Green, Kieran Jack, MCVeigh, Montana, Travis Varcoe are all ideal.