Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Maiden1

Pages: [1] 2 3 ... 40
General discussion / Re: Excel Questions
« on: May 24, 2014, 03:14:19 PM »
Change the code in E1 to =SUM($A$1:$A$3) .  You can change other cells and it won't change the range.

you can do this, but in a spreadsheet you would probably have wanted to copy the formula.
Using the "everything up to current row/column" is a reasonable default for SUM, you can always change it.
But formulas changing because of the alteration of cells not in the range covered by the formula is not on.

Definitely strange it does that.  Another way to do the formula is below where it offsets by 2 cells.  You can copy the formula using this.


General discussion / Re: Excel Questions
« on: May 24, 2014, 02:57:18 PM »
Change the code in E1 to =SUM($A$1:$A$3) .  You can change other cells and it won't change the range.

GAA Discussion / Re: Paul Hearty 17 SFC medals Is this a record. ?
« on: October 29, 2013, 04:57:02 PM »
St Vincents Dublin contested every football final but 2 between 1948 to 1977 (winning 23).  They won 8 hurling titles between 1953 and 1967. 

Kevin Heffernon has 15 football and 6 hurling championships.  There may be others that have more combined medals (Heffernan quit hurling when he was 29).  e.g.  The Fergusons would have played more hurling, even if they had more football medals and played football alongside Heffernan.  Des won a couple of additional senior football championships when he moved to Meath.

General discussion / Re: Things that make you go What the F**k?
« on: April 08, 2012, 12:24:36 PM »

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.

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


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

There may be better ways of populating the cells.

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 :)

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:


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

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
        If Cells(intCurrentRow, 1) > 984 Then
            intCurrentCount = intCurrentCount + 1
            intCountConsecutive = intCountConsecutive + 1
            If intCountConsecutive < 5 Then
                If intMaxCount < intCurrentCount Then
                    intMaxCount = intCurrentCount
                End If
                intCurrentCount = 0
            End If
            intCountConsecutive = 0
        End If
    End If


Cells(1, 3) = intMaxCount

End Sub

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
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.

GAA Discussion / Re: Quiz question
« on: February 17, 2012, 04:53:02 PM »
Jimmy Barry Murphy came close to winning the lot.

Munster U21
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.

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.

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.

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.

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

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.

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 ::)

Pages: [1] 2 3 ... 40