Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.82 seconds.

  1. Re: VBA: If Range Contains Cell Value Copy than del

    Almost. If you want to operate on sheet "path" I would add the blue bits and remove the red bits. Also, always best to declare (Dim) your variables.

    Sub Poster_Index()
    Dim ws As Worksheet

    ...
  2. Re: Splitting out title, first name, middle name, last name

    If you are happy to deal with the few miscreants that kweaver's formula might leave, then here are some considerably more compact formulas that I think should still do the same job.

    <b>Extract...
  3. Re: IF any of 10 columns equals any of 4 other columns

    Have I understood correctly?

    <b>interference</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff;...
  4. Re: VBA: If Range Contains Cell Value Copy than del

    Give this a try in a copy of your workbook.
    I have assumed no empty cells among the column A data & same for column C.


    Sub Poster_Index()
    With Range("A1:E" & Range("C" &...
  5. Replies
    13
    Views
    168

    Re: Sum numbers between two specific cells

    Edit: Oops, FormR posted basically same thing while I was composing my post. :)

    See if this is any use. It doesn't matter whether the 2 specified numbers are in the correct order (left to right)...
  6. Re: How do I automatically count the finished goods of raw Materials?

    Duplicate to https://www.mrexcel.com/forum/excel-questions/1107631-countif.html

    Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per...
  7. Replies
    8
    Views
    229

    Re: 0 formula with blank cells

    :confused: I don't really understand that as the idea of the TEXTJOIN function was to completely replace the longer original formula.

    Anyway, if you have something that you are happy with that's...
  8. Re: INDEX / MATCH / OFFSET / AVERAGE Formula

    Welcome to the MrExcel board!

    Because the OP wanted to start the average 1 column to the right of where the 22222 was found in the heading row and end the average 3 columns to the right of where...
  9. Re: Help with VBA for background color in selected cells.

    Good idea to try a fresh start! You're welcome. :)
  10. Replies
    7
    Views
    193

    Re: Count of cell blocks

    Ah, not your mistake. I just didn't realise that you were using my sample data where I had changed that 2 to a 1. :)
    Now I understand.

    OK, I'm assuming the use of the regular expression UDF...
  11. Replies
    76
    Views
    6,524

    Re: Extract multiple keywords from text string

    No problem. Same to you. :)
  12. Replies
    17
    Views
    256

    Re: get value from cell in a range

    Firstly, given the above, would you still be interested in a standard formula solution?

    If so, let's consider thisIf L3 does in fact contain a space (or spaces) then that would mean that "KIRBY...
  13. Replies
    7
    Views
    193

    Re: Count of cell blocks

    OK, understand that now. My codes need a slight tweak to account for that - see below.

    First part doesn't make sense to me. Given your answer to 1 above, Jan had 4 appointments in the first block...
  14. Replies
    76
    Views
    6,524

    Re: Extract multiple keywords from text string

    Try

    Sub Components_v4()
    Dim RX As Object
    Dim aResults As Variant
    Dim c As Long, i As Long, ubaResults As Long, lr As Long
    Dim sComp As String

    Set RX =...
  15. Re: Hide Multiple number of rows based on a value

    Welcome to the MrExcel board!

    The details and example you gave don't quite add up to me. You said on Testing Records that data can be entered from row 5. With your example of 350 you said rows 351...
  16. Re: VBA If And Or query on strings containing times

    Sorry, didn't mean to offend (said it with a smilie face & as a tip for the future). :)
  17. Replies
    17
    Views
    256

    Re: get value from cell in a range

    Hmm, that seems strange. Could you either do what Mento82 has suggested or when you get the #REF ! error (with no merged cells), tell me ..

    - what cell the only text is in
    - what that text is
    -...
  18. Replies
    3
    Views
    82

    Re: Ranking Groups with Multiple Criteria

    You're very welcome. Thanks for the follow-up. :)
  19. Re: Macro/VBA help. Insert Sum() to bottom of numbers, continuously in column, till end.

    Instead of doing that, consider just removing this bit of code altogether, so you only do anything if fr>0.


    End Select
    If fr > 0 Then
    .FormulaR1C1 = "=SUM(R" & fr &...
  20. Re: Lowest decimal place value from a range of data

    .. and the little ones in post 9?
  21. Re: Macro/VBA help. Insert Sum() to bottom of numbers, continuously in column, till end.

    Example 1
    In column E the only numbers are in E5:E7
    You select E22
    Autosum will suggest =SUM(E5:E21)
    My code gives error because you said to add up to the first empty cell and that is E21 which...
  22. Re: Lowest decimal place value from a range of data

    Try these

    <b>Decimal</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt;...
  23. Re: Lowest decimal place value from a range of data

    I know that. ;)

    .. but then neither does yours in some circumstances. :)

    <b>Decimal</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial;...
  24. Re: Macro/VBA help. Insert Sum() to bottom of numbers, continuously in column, till end.

    Give this a try. It doesn't exactly match the Autosum behaviour but may suffice for you. If not, specific examples of data, location and expected result would help.


    Sub InsertSUMformula()
    Dim...
  25. Replies
    76
    Views
    6,524

    Re: Extract multiple keywords from text string

    You're welcome. Glad we got there in the end. :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4