Messages

1

General discussion / Re: Things that make you go What the F**k?

« on: April 08, 2012, 12:24:36 PM »

http://www.bbc.co.uk/sport/0/rowing/17645929

Right don't know what to make of this. Clearly it's a bit mad but, was this a sabotage or just an act of stupidity?

Think some sort of protestor. They have been charged with a public order offence.

http://elitismleadstotyranny.squarespace.com/

2

General discussion / Re: Excel Questions

« on: March 07, 2012, 02:24:13 PM »

Something like below should work if the values you are looking for are in Sheet2 in top left corner.

Then if you enter X3 in Cell A:1 in Sheet1

and have below in cell B:1

=IF(ISNA(VLOOKUP(A1,Sheet2!$A1:$C3,2,FALSE)),"",VLOOKUP(A1,Sheet2!$A1:$C3,2,FALSE))

Cell B:1 would have value 'Thing 3'.

There may be better ways of populating the cells.

3

General discussion / Re: Excel Questions

« on: March 01, 2012, 08:00:17 PM »

That works maiden, getting my head around it now, thanks again. Where's the applause smile??? This one will have to do 






 

haha good stuff

4

General discussion / Re: Excel Questions

« on: February 29, 2012, 09:12:57 AM »

Thanks lads. Was thinking of something like Hardy's but macros might be what I'm really after, excel skills are poor to never used, thanks for the idea and the work Maiden.

Did a bit of coding in college so just stepping through your code am I right in thinking that will just return the maximum number of consecutive rows that are greater than 984?

I need to record every instance where there is at least 10 consecutive entries great than 984 (remember there can be a gap of one entry less that 984 after at least 5 consecutive entries as long as it is followed by another 5 consecutive entries greater than 984). Ideally row C will store every instance of these consectutive entries so, for example, if you take the instance of all the numbers in my previous post the output would be:

15
13

I suppose I can use something like the below to save each consecutive count number once it reaches two entries less than 984?

intSaveRow + 1
Cells(intSaveRow , 3) = intCountConsecutive

Yes that is correct it only records the maximum in row 1,3

If you want to record everytime it > 15 then

Where it has

                If intMaxCount < intCurrentCount Then
               
                    intMaxCount = intCurrentCount
               
                End If

Change that to

                If intCurrentCount >= 15 Then
               
                        Cells(intCurrentRow - 2, 3) = intCurrentCount
               
                End If

5

General discussion / Re: Excel Questions

« on: February 28, 2012, 03:19:00 PM »

I was thinking something like above  or you could write a macro something like below to do a max count if all the values where always in column A.

Private Sub cmdCount_Click()

Dim intCurrentCount As Integer
Dim intCurrentRow As Integer
Dim intCountConsecutive As Integer
Dim intMaxCount As Integer
Dim blnFound As Boolean

blnFound = True
intCurrentCount = 0
intCurrentRow = 0
intMaxCount = 0

While blnFound

    intCurrentRow = intCurrentRow + 1
   
    If Cells(intCurrentRow, 1) = "" Then
   
        blnFound = False
   
    Else
   
        If Cells(intCurrentRow, 1) > 984 Then
           
            intCurrentCount = intCurrentCount + 1
            intCountConsecutive = intCountConsecutive + 1
       
        Else
       
            If intCountConsecutive < 5 Then
           
               
                If intMaxCount < intCurrentCount Then
               
                    intMaxCount = intCurrentCount
               
                End If
               
                intCurrentCount = 0
           
            End If
           
       
            intCountConsecutive = 0
           
        End If
   
    End If


Wend


Cells(1, 3) = intMaxCount

End Sub

6

GAA Discussion / Re: Quiz question

« on: February 17, 2012, 09:51:39 PM »

Oisin has 15 Armagh County Medals(including 13 in a row)
God knows how many Armagh league medals
Countless underage medals
9 Ulster Club Medals
5 All-Ireland Club Medals (soon to be 6)

With the County,

7 Ulsters
1 NFL
2 All- Stars
1 All-Ireland

Before Oisin, Rangers never won anything outside Armagh, and Armagh never won anything full stop.

Has to be the most underrated player ever.  Guaranteed 4 points plus and win a couple of handy frees whether in the first round of the Armagh club championship or the AI final.

7

GAA Discussion / Re: Quiz question

« on: February 17, 2012, 04:53:02 PM »

Jimmy Barry Murphy came close to winning the lot.

Minor
Munster U21
Senior
NFL
Railway Cup
2 Club All Irelands

When you add that he won everything going in hurling as well and got to a FAI cup final with Cork Celtic it is not a bad feat.

8

General discussion / Re: Only in America

« on: February 10, 2012, 04:27:38 PM »

5 million cans between 12 people in a year, so that would be 1141 cans per day per person  , no wonder the children have foetal disorders.

9

General discussion / Re: Gay marriage

« on: February 10, 2012, 10:37:51 AM »

Firstly. I've no problem with gay people adopting. I see no logical reason why a gay couple would be any better or worst than a heterosexual couple. Can I throw out a new question? Do civil partnership get the same tax breaks as a married couple? If they do is there any reason why for instance 2 sisters who live together could not be afforded the same rights?if they lived together 5/10/15 years.

http://www.jordanssolicitors.co.uk/resource/inheritance-tax-sisters-lose-test-case/

10

General discussion / Re: An Unexpected Road

« on: February 07, 2012, 12:10:16 AM »

LL great post and totally honest. Congratulations. Children are a blessing and each one is different and I am sure your son will give you much to be proud of. Benny Coulterr paid a lovely tribute to his brother in his column in the Irish News a while back. Worth a read.
God Bless

I believe it was Tierney, a great piece.

As was your piece LL, best of luck, brilliant post. Don't be a stranger to the board even when busy changing nappies!

Mick O'Connell has spoken many times about the gift of his son Diarmuid.

http://catholichotdish.com/embracing-life/the-greatest-gift-i-was-ever-given/

The best we can hope for any of our children is that they will be happy in whatever path there lives take.

11

General discussion / Re: SUFTUM

« on: January 21, 2012, 08:55:24 PM »

Ulster could have won that game, would have been a huge advantage to have a home quarter final.  They had a kickable penalty with 5 minutes to go when 5 behind then someone gave out to the ref and he swapped the penalty. They got another penalty with time up and had to then go for the try. Silly mistake.

12

General discussion / Re: Excel Questions

« on: December 12, 2011, 01:35:48 PM »

If you don't mind having extra columns you can highlight all the cells that you want to format then use

Data>Text to Columns>

Then have the delimiter as    :

Will create 4 columns as below, highlight all these rows and you can do find and replace for all the letters then.

d24   h21   m44   s27.
d17   h02   m59   s50.
d10   h04   m51   s19.
d08   h04   m28   s51.
d08   h04   m03   s06.
d07   h04   m47   s07.
d07   h04   m45   s04.
d06   h12   m56   s43.
d03   h05   m06   s02.
d02   h20   m57   s23.
d02   h19   m57   s08.
d02   h14   m19   s03.

You could always just do mid like above though

13

General discussion / Re: Anyore in coppers 26th August 2010??

« on: December 03, 2011, 09:01:18 AM »

I was in there yesterday at lunch time and they were doing , beef or bacon or fish carvery with all the veg  for €.50 or you could have lasagne for €6.50.

€0.50 for real!! 

In my Dublin days we had lunch in it regular - the main carvery chef was a big guy, sweat pumping off him and all he'd say was "All the veg?" and then he'd dish it up - you'd end up with Mash, Chips, Roast, Garlic Spuds plus a Corquette the odd day plus the two veg of the day. Would take you a few hours to function at any level afterwards if you went the full hog.

Had the odd Corkette there myself back in the day, but I never ate there,

What went on with you and the odd Corkette is no one elses business.

Write to Santa and ask for an SOH rapido.

Lost in translation, too much vodka.  U are usually the one with the crap jokes!!!

14

General discussion / Re: Anyore in coppers 26th August 2010??

« on: December 02, 2011, 10:52:51 PM »

I was in there yesterday at lunch time and they were doing , beef or bacon or fish carvery with all the veg  for €.50 or you could have lasagne for €6.50.

€0.50 for real!! 

In my Dublin days we had lunch in it regular - the main carvery chef was a big guy, sweat pumping off him and all he'd say was "All the veg?" and then he'd dish it up - you'd end up with Mash, Chips, Roast, Garlic Spuds plus a Corquette the odd day plus the two veg of the day. Would take you a few hours to function at any level afterwards if you went the full hog.

Had the odd Corkette there myself back in the day, but I never ate there,

What went on with you and the odd Corkette is no one elses business.

15

General discussion / Re: Gary Speed RIP

« on: November 28, 2011, 11:02:21 AM »

I was talking to someone who deals with this type of thing this morning..  I was asking what sort of affect she thinks this would have on people in general and she said that if he is built up into a sort of hero through the media with what he has done given added mystique etc. then this is very dangerous.  If this is dealt with in the right way that brings the issue out into the open more and people start to talk more freely about having depression etc. and not feel stigmatised then this could have a positive effect on people.