Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.88 seconds.

  1. Re: Split full name w/single and multiple middle names

    The SUBSTITUTE puts 50 spaces between each word.
    Taking the RIGHT 50 characters will give some spaces followed by the last word.
    TRIM removes the spaces leaving you with the last word.
    The rest is...
  2. Re: Split full name w/single and multiple middle names

    You're welcome. Thanks for the confirmation. :)
  3. Re: Split full name w/single and multiple middle names

    Like this?

    <b>Names</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;...
  4. Replies
    7
    Views
    116

    Re: FIND Question

    You cannot upload actual workbooks in this forum. In any case I am generally not a fan of working with actual workbooks from members as they often turn out to take too long to figure out what the...
  5. Replies
    7
    Views
    136

    Re: Noob Help Please

    Sounds like there might be some sheet protection and/or vba code going on in your workbook. However, it seems the formula solution suggested by Fluff is meeting your needs so I guess we don't need to...
  6. Replies
    7
    Views
    273

    Re: Splitting Row Data

    You're welcome. Thanks for the confirmation. :)
  7. Replies
    3
    Views
    113

    Re: Multiple Lookup Values

    Can you state what the results for your sample data should be and set out the steps that you would do manually to get those results?
  8. Replies
    4
    Views
    128

    Re: Lookup across multiple columns

    You cannot attach an actual workbook, but you can show small screen shots like I have here. My signature block below has help with that.

    <b>Excel 2016</b><table cellpadding="2.5px" rules="all"...
  9. Replies
    3
    Views
    89

    Re: conditional formatting

    No idea at all unless you explain clearly in what way it "will not work"

    1. Is my sample data above unrealistic? (I made it according to "each cell has a date in each date is later than the...
  10. Re: if cell contains text from list then return value

    This is why post 2 asked for specific details. ;)

    Try this.
    It is an array formula so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed...
  11. Replies
    7
    Views
    136

    Re: Noob Help Please

    That doesn't make any sense to me. The suggestion involved applying AutoFilter copying what you wanted and removing Autofilter. I cant see how that could possibly affect what you subsequently want to...
  12. Replies
    3
    Views
    154

    Re: Nested If in VBA Macro

    You're welcome. Glad it helped. :)
  13. Re: if cell contains text from list then return value

    Is this what you mean? If not, more details or examples please.

    <b>Check List</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt;...
  14. Re: Help copying data and transpose from one sheet to new sheet

    Welcome to the MrExcel board!

    This is my take on what you require. Check sheet names in the code & I have assumed that the 2nd sheet already exists but has no data (at least in columns A:E)
    ...
  15. Replies
    4
    Views
    128

    Re: Lookup across multiple columns

    Welcome to the MrExcel board!

    It isn't clear to me.
    What are the expected results for the sample data and how do you get them manually?
  16. Re: VBA Help - Speed up a For Each Statement

    Good news. :)
    What has the 40 second run-time come down to now?
  17. Re: VBA Help - Speed up a For Each Statement

    Suggest that you always include that information in your first post, or thread title, or signature as the more common happening here is that if unstated, we tend to assume a Windows operating system....
  18. Re: VBA Help - Speed up a For Each Statement

    That isn't surprising since that is exactly what your code from post 1 does too & Dante was just giving you a faster way, which is what you asked for. ;)

    This is my suggestion for what I think you...
  19. Replies
    7
    Views
    136

    Re: Noob Help Please

    Welcome to the MrExcel board!

    Another option.
    - Put AutoFilter on column F and Filter for 'Yes'
    - Manually select all of what you see below the column B heading and Copy/Paste it to wherever you...
  20. Re: INDIRECT formula with Relative Column References

    If I have understood correctly then you could also swap to VLOOKUP, only requiring one INDIRECT function.

    =VLOOKUP($C$8,INDIRECT("'"&$A11&"'!C:J"),4+COLUMNS($B11:B11),0)
  21. Re: Copy and Paste Row not working when filtered

    The code works for me. The only time it inserts a blank row is if the active cell is in a blank row & in that case inserting a blank row is what I would expect.
    We don't know what your data is...
  22. Replies
    3
    Views
    89

    Re: conditional formatting

    See if this is what you want. (My dates are in d/m/y format)
    - Select B1:Bxx and apply the CF shown for B1
    - Select C1:Cxx and apply the CF shown for C1
    etc

    <b>CF Date</b><br /><br /><table...
  23. Replies
    7
    Views
    273

    Re: Splitting Row Data

    There seems to be an issue with the results in column D, both about the values returned
    a) eg the last row of your results says SRN2168-M but that looks like it actually comes from column F
    b) The...
  24. Replies
    4
    Views
    75

    Re: Help with Excel Formula

    I am unable to reproduce your problem.
    My dates are in d/m/y format but that shouldn't be an issue. In D2 of Calculation I have the date 23/10/2019

    I was able to enter your formula into the...
  25. Replies
    7
    Views
    116

    Re: FIND Question

    Is one of these what you want? If not please give a small set of dummy sample data & explain in relation to that. Remember that you are very familiar with your layout, data and aim, but we are not....
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4