Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.33 seconds.

  1. Replies
    4
    Views
    72

    Re: Nestled IF with COUNTIFS question

    Try it like
    =IFERROR(LOOKUP(2,1/COUNTIFS('Master attendance'!$A:$A,"GROUP 1",'Master attendance'!$D:$D,Aspire!I$1,'Master attendance'!$C:$C,"Launch event",'Master ...
  2. Replies
    5
    Views
    67

    Re: InStr() within a Range, mistmatch error

    If you just want to see if the string occurs anywhere in the range use
    MsgBox IIf(InStr(1, Join(Application.Transpose(Range("A1:A200").Value), "|"), "All Formulas", vbTextCompare) > 0, "yes", "no")
  3. Replies
    14
    Views
    201

    Re: TRIM in VBA on a Range

    Whilst I still use the If function, as most people are not using 365, it seems that it's no longer needed. I've tried it with various different formulae & it works without the If.
    I'm guessing that...
  4. Replies
    14
    Views
    201

    Re: TRIM in VBA on a Range

    Or, for anyone using Office 365
    Sub TrimRange()
    [A1:A6000] = [Trim(A1:A6000)]
    End Sub
  5. Replies
    15
    Views
    136

    Re: Vlookup with multiple occurances of a value

    Glad to help & thanks for the feedback
  6. Replies
    3
    Views
    27

    Re: Advice with VBA Code to Move Files

    How about
    Sub purceld2()
    Dim Fso As Object
    Dim Cl As Range
    Dim Fldr As String

    Set Fso = CreateObject("scripting.filesystemobject")
    With Application.FileDialog(4)
    ...
  7. Replies
    15
    Views
    136

    Re: Vlookup with multiple occurances of a value

    It already does that ;)
  8. Replies
    15
    Views
    136

    Re: Vlookup with multiple occurances of a value

    Ok, how about
    Sub Hyp40()
    Dim Cl As Range
    Dim Ws1 As Worksheet, Ws2 As Worksheet
    Dim Sp As Variant
    Dim i As Long

    Set Ws1 = Sheets("Master")
    Set Ws2 = Sheets("Sheet1")
    ...
  9. Replies
    15
    Views
    136

    Re: Vlookup with multiple occurances of a value

    That's possible, but are you looking up a list of postcodes, or just 1?
    Because if it's a list then B13:D14 should be returning the values from A13:A14
  10. Replies
    15
    Views
    136

    Re: Vlookup with multiple occurances of a value

    Ok, you have a list of postcodes in col A & in cols B:D you want to return the details from the master sheet, if they exist.
    If the postcode in(for instance) A12 exists 3 times in the master list,...
  11. Replies
    3
    Views
    110

    Re: Sum of sum criteria

    You could put
    =SUM(C3:F3)
    in another column, drag down & then use
    =SUMIF(G3:G15,0,A3:A15)
  12. Re: Sumifs multiple but same criteria, better solution?

    Duplicate https://www.mrexcel.com/forum/excel-questions/1110294-sum-sum-criteria-post5344587.html#post5344587

    Please do not post the same question multiple times. All clarifications, follow-ups,...
  13. Replies
    11
    Views
    210

    Re: proper syntax for With Rng/Evaluate?

    Like
    Sub ilcaa()
    Dim Strategy As String
    Strategy = "36"
    With Range("A1", Range("A" & Rows.Count).End(xlUp))
    .Value = Evaluate("If({1},""" & Strategy & ", ""&" & .Address & ")")
    ...
  14. Replies
    15
    Views
    136

    Re: Vlookup with multiple occurances of a value

    The answer to part 3 is less than helpful. ;)

    Whereabouts on the sheet do you want it put, and how should it handle the multiple entries?
  15. Replies
    3
    Views
    27

    Re: Advice with VBA Code to Move Files

    How about
    Sub purceld2()
    Dim Fso As Object
    Dim Cl As Range
    Dim Fldr As String

    Set Fso = CreateObject("scripting.filesystemobject")
    With Application.FileDialog(4)
    ...
  16. Replies
    11
    Views
    210

    Re: proper syntax for With Rng/Evaluate?

    You're welcome & thanks for the feedback
  17. Re: Running multiple macros with one command button on userform

    In that case as long as your removed the "Private" from the start of the procedure names. Your code should work.
  18. Re: Running multiple macros with one command button on userform

    Are those commandbuttons on a sheet called sheet1?
    And are they ActiveX command buttons?
  19. Replies
    11
    Views
    210

    Re: proper syntax for With Rng/Evaluate?

    How about
    Sub ilcaa()
    With Range("A1", Range("A" & Rows.Count).End(xlUp))
    .Value = Evaluate("If({1},""36, ""&" & .Address & ")")
    End With
    End Sub
  20. Thread: Case "Question"

    by Fluff
    Replies
    9
    Views
    128

    Re: Case "Question"

    Just a word of warning, Sheet1 is NOT the same as worksheet(1).
    Sheet1 is the codename of the sheet & will appear in the Project window in alphabetical order.
    Worksheets(1) is the sheet index &...
  21. Replies
    15
    Views
    136

    Re: Vlookup with multiple occurances of a value

    A few questions
    1) Which column holds the postcode?
    2) Which columns do you want to return?
    3) Where do you want that information put?
  22. Replies
    5
    Views
    97

    Re: Minimizing utility

    It's the Rugby World Cup logo. :)
  23. Replies
    14
    Views
    132

    Re: VLOOKUP Returns #NA when data is present

    In that case the one on the new sheet is text not a number
  24. Replies
    10
    Views
    87

    Re: Check to see if sheet exists and rename it

    52 is the fileformat (in this case .xlsm) I find it safer than using the format name (ie xlOpenXMLWorkbook)
  25. Replies
    14
    Views
    132

    Re: VLOOKUP Returns #NA when data is present

    Does the ISNUMBER return true for both?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4