Search:

Type: Posts; User: rory; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    8
    Views
    131

    What happens if you use: [Last name] =...

    What happens if you use:

    [Last name] = "D''amico"

    instead? (I am assuming the weird quotation marks in your post are not actually in your query)
  2. Replies
    12
    Views
    588

    Just on the pointers thing, if you use VBA you...

    Just on the pointers thing, if you use VBA you are probably using pointers most of the time since the default way of passing arguments is ByRef. :)
  3. Replies
    8
    Views
    131

    Here's one way - it's more complicated than Excel...

    Here's one way - it's more complicated than Excel though!
  4. Replies
    6
    Views
    121

    Do you see any mention of Circular references in...

    Do you see any mention of Circular references in the status bar at the bottom?
  5. Replies
    8
    Views
    131

    Access tables have no real concept of record...

    Access tables have no real concept of record order so that kind of approach won't work. I'll have a think about a query approach but you might be better off posting in the Access forum.
  6. Replies
    8
    Views
    131

    Assuming that if the next start date is not one...

    Assuming that if the next start date is not one day after the previous end date, it counts as a new job, you could add a new column A and use this formula:...
  7. Replies
    15
    Views
    299

    That's a corrupted version of rounders, is it not?

    That's a corrupted version of rounders, is it not?
  8. Replies
    15
    Views
    299

    Nothing. The examples shown had dates in...

    Nothing. The examples shown had dates in ascending order and the logic of the question made me figure it was probably a safe bet that it would be sorted that way. I should have mentioned the...
  9. Replies
    15
    Views
    299

    Straight formula method: ...

    Straight formula method:

    =MATCH(TODAY(),$C$1:$C$20,0)-LOOKUP(2,1/($C$1:$C$20<TODAY())/($F$1:$F$20="no"),ROW($C$1:$C$20))
  10. Thread: Formula help

    by rory
    Replies
    14
    Views
    269

    I'm not sure. That's what I assumed, but the...

    I'm not sure. That's what I assumed, but the sample doesn't clearly state either way.
  11. Thread: Formula help

    by rory
    Replies
    14
    Views
    269

    Also note that our formulas do not do the same...

    Also note that our formulas do not do the same thing. Mine assumes the three "comp" values must be for the same code in column A as the current row, whereas Maud's just assumes any three "comp"...
  12. Thread: Formula help

    by rory
    Replies
    14
    Views
    269

    It seems the forum added a space after Comp in my...

    It seems the forum added a space after Comp in my formula, which shouldn't be there. It's:

    =IF(AND(OR(C2={"red","del"}),COUNTIFS(C$1:C1,"Comp",A$1:A1,A2)<3),1,"")
  13. Thread: Formula help

    by rory
    Replies
    14
    Views
    269

    Can you post your new workbook?

    Can you post your new workbook?
  14. Thread: Formula help

    by rory
    Replies
    14
    Views
    269

    Assuming the last three rows should all be 1, as...

    Assuming the last three rows should all be 1, as there are only 2 rows of comp for code dd prior to that, the formula would be:
    ...
  15. FYI, buttons can call functions - you just have...

    FYI, buttons can call functions - you just have to type the name in. So you could assign:
    'zSelectPrinter False'
    as the "macro". Note you need the single quotes as you are passing an argument...
  16. I use this function to return the correct port...

    I use this function to return the correct port for a given printer name:

    Public Function GetPrinterPort(strPrinterName As String) As String
    Dim objReg As Object, strRegVal As String, strValue...
  17. Replies
    3
    Views
    171

    There isn't a format for always rounding up....

    There isn't a format for always rounding up. Duplicating the cells would probably be easiest.
  18. Replies
    19
    Views
    1,416

    Excel doesn't have built-in constants, other than...

    Excel doesn't have built-in constants, other than in VBA.
  19. Replies
    19
    Views
    1,416

    Of course, you don't need to put it in a cell to...

    Of course, you don't need to put it in a cell to name it. You can just define a name Infinity that refers to ="∞"
  20. Replies
    8
    Views
    422

    Just FYI, I'd stick with the API version over the...

    Just FYI, I'd stick with the API version over the DataObject code. There's a bug in Win8 using DataObject which can lead to the clipboard just containing two odd characters rather than whatever text...
  21. Thread: find col and row

    by rory
    Replies
    18
    Views
    734

    Um, yes you did. ;)

    Um, yes you did. ;)
  22. Thread: which is faster?

    by rory
    Replies
    19
    Views
    535

    Thankfully I have 2010 now. :)

    Thankfully I have 2010 now. :)
  23. Thread: which is faster?

    by rory
    Replies
    19
    Views
    535

    No, not entirely. Probably about 80-90%...

    No, not entirely. Probably about 80-90% compatibility.
  24. Thread: which is faster?

    by rory
    Replies
    19
    Views
    535

    Sorry typo - yes it should be H2, not H" ...

    Sorry typo - yes it should be H2, not H"

    COUNTIFS should be faster than SUMPRODUCT generally. You could also use another helper column that concatenates columns E and G and then just use COUNTIF.
  25. Replies
    3
    Views
    362

    Have you tried using the ISNULL on the D.Amount...

    Have you tried using the ISNULL on the D.Amount in the Subquery?
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4