Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.94 seconds.

  1. Replies
    8
    Views
    218

    Re: Why 1004 Run Time error at Red Text?

    If the message box produced a range, then the range isn't the problem (it's OK that it's 'larger than' your actual data. Smaller may have been an issue).

    So it must be the ctiteria that is the...
  2. Replies
    8
    Views
    218

    Re: Why 1004 Run Time error at Red Text?

    Maybe the 'Current Region' isn't quite what you think it is..

    Add this line in there, and what does the message box say?


    With Sheets("DataDump").Range("A1").CurrentRegion
    MsgBox .Address...
  3. Re: Delete Rows If Contains Certain Multiple Values

    Try


    Sub delete_exempt()
    Dim c As Range, MyVals As Range, SrchRng As Range
    Dim i As Long, lr1 As Long, lr2 As long, x

    'This is a range containing all the criteria to search for
    lr1 =...
  4. Re: Delete Rows If Contains Certain Multiple Values

    Welcome to the board.

    I think a different approach should be used here.
    The code in this thread worked because it was assumed the value would only exist once.

    You probably need to go row by...
  5. Re: Formula - return bottom non-blank value in a range

    Cutting ranges in half...

    original list of numbers
    1 2 3 4 5 6 7 8 9 10

    Lookup cuts it in half, and looks at the last number of each half..
    1 2 3 4 5 (Is 5 greater than the lookup value?)
    If...
  6. Re: Formula - return bottom non-blank value in a range

    You're welcome..
    9.99999999999999E+307 is just the scientific notation for the largest number allowed in a cell, also called Bignum.

    Lookup assumes your data is sorted in ascending order (it...
  7. Re: Formula - return bottom non-blank value in a range

    Finding the furthest down 'numeric' value, try

    LOOKUP(9.99999999999999E+307,$N$27:$N49)
  8. Replies
    3
    Views
    214

    Re: Question regarding looking up values

    You're welcome.
  9. Re: Simple SUMIFS going wrong - I'm doing something dumb

    Welcome to the board.

    Try

    =SUMIFS('DATA'!C:C, 'DATA'!A:A, 'Results'!A2,'DATA'!B:B,'RESULTS'!B3)
  10. Replies
    4
    Views
    303

    Re: Count ALL days in a month, except Sunday

    You're welcome.
  11. Replies
    4
    Views
    303

    Re: Count ALL days in a month, except Sunday

    Which version of Excel are you using?
    This is for XL2010+
    Assuming A1 is the FIRST day of a given month

    =NETWORKDAYS.INTL(A1,EOMONTH(A1,0),11)
  12. Replies
    3
    Views
    161

    Re: Code Works, but only sometimes?

    You're welcome.
  13. Replies
    3
    Views
    161

    Re: Code Works, but only sometimes?

    When nesting ranges, and you specify the book/sheet on the outside range, you must also specify it on the inside ranges too.
    Also, you can't select a sheet that is not currently active. (you don't...
  14. Replies
    3
    Views
    214

    Re: Question regarding looking up values

    Try

    MATCH(""" & intPmtFreq & """,MMQSAA,0),
  15. Thread: Adding Zeroes

    by Jonmo1
    Replies
    3
    Views
    202

    Re: Adding Zeroes

    Welcome to the board.

    In File - Options - Advanced.
    UNcheck "Automatically insert a decimal point"
  16. Replies
    3
    Views
    62

    Re: complex if formula

    You're welcome.
  17. Replies
    3
    Views
    62

    Re: complex if formula

    Try

    =IFERROR(INDEX('different tab'!$S:$S,MATCH(A9,'different tab'!$B:$B,0))/J9,"")
  18. Thread: Countif problem

    by Jonmo1
    Replies
    1
    Views
    124

    Re: Countif problem

    Yes, the * is being treated as a wildcard.

    Try
    =countif($A$1:$A$2000;SUBSTITUTE(EG43;"*";"~*"))
  19. Re: VBA - If two different ranges contain values

    Try

    If Range("A1").Value = "xxx" And Range("A3").Value <> "" Then
  20. Replies
    2
    Views
    152

    Re: Sumifs+sumifs+sumifs

    That isn't necessarily a bad thing.
    I wouldn't put 'length of formula' high on my list of criteria when judging the quality of a formula.
    A couple rules of thumb come to mind.
    Shorter does not...
  21. Replies
    2
    Views
    152

    Re: Sumifs+sumifs+sumifs

    Welcome to the board.

    Try

    =SUMPRODUCT(SUMIFS(Sheet1!$U$2:$U$100000,Sheet1!$A$2:$A$100000,'Pack Sizes'!$A$5:$A$11,Sheet1!$T$2:$T$100000,B$2))
  22. Replies
    10
    Views
    247

    Re: wildcard in named range in formula

    No worries. You're not the first, and you won't be the last to misread something on the internet :rofl:
  23. Replies
    10
    Views
    247

    Re: wildcard in named range in formula

    You're welcome.
  24. Re: Counting results from IF function over an entire data set

    For what it's worth..

    This is not absolute proof that the 2 cells are 'numeric'.
    They could be numbers stored as text, and the + action is converting them to numbers, but the SUM function would...
  25. Replies
    10
    Views
    247

    Re: wildcard in named range in formula

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4