Posts by Sicarii

So I've been out of the Excel arena since 2009 and now needing to use it again. I feel like I should know this, but the whole midnight thing is throwing me off. I just want to compare if a time falls within a start/end range.

Lost my job in 2009 where I used Excel everyday and have recently entered a job scope where I need to get brushed up. Damn, I seen the sub about Dave...he always had excellent answers. I feel bad for those that loved him

Re: VBA code to update the next cell in a column according to time!?

could you attach a sample file?

Re: Changing formula based upon word input

I still fail to see how you get to 82.9

Re: COUNTIF with two variables

edit: oops, someone posted already, guess I should've refreshed first
something along the lines of this help?

=SUMPRODUCT((A1:A6="a")*(B1:B6=4))

Re: Set range variables without run-time error!

Sub blah()
Dim LastRow As Long
    LastRow = Range("B65536").End(xlUp).Row + 1
    
    For x = Range("B" & LastRow).End(xlUp).Row To 9 Step -1
        If IsEmpty(Cells(x, 2)) = "False" Then Cells(x, 3).Formula = "=vlookup(rCell,NoPayCardFile_050712!$A$2:E200,5)"
    Next x
    
End Sub

Re: Run-time error '91': Object variable or With block variable not set

what line gets the error? sample workbooks are always beneficial.

Re: Need to exclude certain metrics

Again...what determines "which" 3 should be brought in? No one can help you with any code to perform something that they have no clue of what it is supposed to do. Or am I just completely missing something here?

Re: Need to exclude certain metrics

If you were to do the process manually, what is the logic behind excluding certain metrics?

Re: If cell equals X return value from other cell

Just to rule this out since you said that the formula stays as text. You did put this first one into cell C25:

Quote

=IF(A5="X",A6,"")

versus:

Quote

C25 =IF(A5="X",A6,"")

Re: Using relative Reference

http://support.microsoft.com/kb/213740

Re: Screen blanks while macro executes

memory?

I wouldn't use screenupdating on/off to display interim results. What is the purpose of showing these interim results? (as in there may be a better solution to what you are trying to achieve)

Re: Finding numbers that sum up to a value

But also 700 of them could possible be the wrong combinations so it might not save you much time. Without knowing how your file is setup....I'd suggest controlling it more by not allowing entries after a certain date or better yet a time stamp for each entry.

http://www.letmegooglethatforyou.com/

This is pretty funny, gives a nice little video tutorial for the intended obtuse user...

Re: Add New Series To Charts

Just a thought...you're telling the code to loop until 'total' is less than 100 yet it starts out being less than 100 so wouldn't that mean it's done?

Maybe something more like this:

Sub Macro6()
    Dim total As Integer
    Dim Taper As Integer
    total = 1
    Taper = 2
    Do Until total = 100


        ActiveSheet.ChartObjects("Chart 3").Activate
        ActiveChart.PlotArea.Select
        ActiveChart.ChartType = xlBubble
        ActiveChart.SeriesCollection.NewSeries
        ActiveChart.SeriesCollection("Total").XValues = "=Data!R" & Taper & "C6"
        ActiveChart.SeriesCollection("Total").Values = "=Data!R" & Taper & "C8"
        ActiveChart.SeriesCollection("Total").Name = "=Data!R" & Taper & "C9"
        ActiveChart.SeriesCollection("Total").BubbleSizes = "=Data!R" & Taper & "C7"
        total = total + 1
        Taper = Taper + 1
    Loop
End Sub

Re: Aaron Kills Bambi

mmm backstraps...I can't wait for the 15th; I've only got 1 package of burger left from my buntin buck last year. I love saving some straps for morel season, springtime here in Michigan. I'm getting so freakin hungry!!!

Re: Sumif A Cell Matches Text When The Text Contains Math Symbols

Thought maybe this would work (found from an answer by SHG elsewhere), but it doesn't:
=SUMIF(D:D,CHAR(139) & " No Project " & CHAR(155),G:G)

SUMPRODUCT will work though:
=SUMPRODUCT(--(D2:D50="< No Project >"),G2:G50)

Re: pet syndrome

That was absolutely beautiful!!!

Re: genies

http://www.ozgrid.com/forum/showthread.php?t=95076

Sorry, had to do it

Re: Developing A Formula

Changing PCI's formula to match your alignments...be sure to thank PCI.