Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.35 seconds; generated 54 minute(s) ago.

  1. Re: Return multiple values in one cell from VLOOKUP

    You're welcome & thanks for the feedback
  2. Replies
    7
    Views
    99

    Re: Breaking split at not 0

    Assuming the first value is in A2, try this in A3 & copy down
    =TEXT(A2+4,"00000000")
  3. Re: Return multiple values in one cell from VLOOKUP

    If you have the TEXTJOIN function you could use
    =TEXTJOIN(", ",1,IF(ISNUMBER(SEARCH(B11,A1:A8)),B1:B8,""))

    Confirmed with Ctrl Shift Enter, not just Enter.
  4. Replies
    10
    Views
    94

    Re: Formatting Half of the Cell data in formula

    Whilst I am an MVP on this site, that does not mean I know everything (far from it).
    Somebody else may come along & prove me wrong.
  5. Re: Return multiple values in one cell from VLOOKUP

    Hi & welcome to MrExcel.
    Try
    =CHOOSE(SUMPRODUCT(--(ISNUMBER(SEARCH(B11,A1:A8)))),
    VLOOKUP("*"&B11&"*",A1:B8,2,FALSE),
    VLOOKUP("*"&B11&"*",A1:B8,2,FALSE)&", "&INDEX(B1:B8,MATCH(B11,A1:A8,0)+1),...
  6. Replies
    10
    Views
    94

    Re: Formatting Half of the Cell data in formula

    Unfortunately I do not believe that is possible.
  7. Thread: Simple IF

    by Fluff
    Replies
    7
    Views
    72

    Re: Simple IF

    Glad we could help & thanks for the feedback
  8. Thread: Simple IF

    by Fluff
    Replies
    7
    Views
    72

    Re: Simple IF

    My suggestion was simply based on your original description.
  9. Re: Keep Top 5 Lines of Filtered Range - Delete the rest

    Scrub the previous code and try this instead
    Dim x As Long, i As Long
    Dim Cl As Range
    Dim Hospital As String

    For x = 1 To 52
    i = 0
    Hospital =...
  10. Re: Automatically name worksheets based on cell values from master sheet

    You're welcome & thanks for the feedback
  11. Re: Automatically name worksheets based on cell values from master sheet

    Oops, I forgot to put the . before cells, it should be
    Sheets.Add(, Sheets(Sheets.Count)).Name = .Cells(i, 1)
  12. Replies
    15
    Views
    153

    Re: Cells changing colour

    Glad to help & thanks for the feedback
  13. Re: Extracting City and State from a cell without commas

    Having re-read the op I think you're right & I have a feeling the the / or - is only in some cells but not all.
  14. Thread: Simple IF

    by Fluff
    Replies
    7
    Views
    72

    Re: Simple IF

    Another way
    =IF(B2="","","k"&RIGHT(B2,1)+1)
  15. Replies
    15
    Views
    153

    Re: Cells changing colour

    Ok, that's right, but the formula should be
    =AND(ISNUMBER($A1),ISNUMBER($B1))
    I forgot to lock the range
  16. Re: Extracting City and State from a cell without commas

    :confused: It's not looking for a space, It's simply pulling everything after the / or -.
    If the op wants to split the data further (or add spaces if needed) then as you've said we'll need to wait...
  17. Re: Automatically name worksheets based on cell values from master sheet

    Yup, use this
    Sheets.Add(, Sheets(Sheets.Count)).Name = Cells(i, 1)
  18. Replies
    3
    Views
    48

    Re: User Forms and Global Variable

    It's because you are declaring them again in the sub. Remove the part in red
    Public wsA As Worksheet, wbA As Workbook
    Sub NewExpense()
    Dim sExpDesc As String, sReplace As String, sAccName As...
  19. Replies
    5
    Views
    119

    Re: Count Unique Values

    Have a look here
    https://exceljet.net/formula/count-unique-text-values-with-criteria
  20. Re: Extracting City and State from a cell without commas

    If this is always the case, you could use
    =MID(A2,FIND("/",SUBSTITUTE(A2,"-","/"))+1,500)
  21. Re: Keep Top 5 Lines of Filtered Range - Delete the rest

    OK, how about

    EDIT:
    Code removed as it was wrong.
  22. Re: Keep Top 5 Lines of Filtered Range - Delete the rest

    Glad you sorted it & thanks for the feedback
  23. Re: Build formula based off value in another Cell

    Glad we could help & thanks for the feedback
  24. Re: Automatically name worksheets based on cell values from master sheet

    How about
    Sub timlh42()
    Dim i As Long

    With Sheets("Sheet1")
    For i = 3 To 30
    If .Cells(i, 1) <> 22 Then
    If Not Evaluate("isref('" & .Cells(i, 1)...
  25. Re: Counting the number of blank cells between a specific value

    Hi & welcome to MrExcel.
    One way
    =AGGREGATE(15,6,COLUMN(B2:F2)/(B2:F2<>""),2)-AGGREGATE(15,6,COLUMN(B2:F2)/(B2:F2<>""),1)-1
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4