Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.89 seconds.

  1. 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...
  2. Replies
    6
    Views
    109

    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...
  3. Replies
    3
    Views
    150

    Re: Nested If in VBA Macro

    You're welcome. Glad it helped. :)
  4. 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;...
  5. 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)
    ...
  6. Replies
    3
    Views
    75

    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?
  7. Re: VBA Help - Speed up a For Each Statement

    Good news. :)
    What has the 40 second run-time come down to now?
  8. 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....
  9. 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...
  10. Replies
    6
    Views
    109

    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...
  11. 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)
  12. 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...
  13. Replies
    2
    Views
    63

    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...
  14. Replies
    6
    Views
    242

    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...
  15. Replies
    4
    Views
    70

    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...
  16. Replies
    4
    Views
    74

    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....
  17. Replies
    4
    Views
    70

    Re: Help with Excel Formula

    The link does not work for me.
  18. Replies
    6
    Views
    242

    Re: Splitting Row Data

    So what would the expected results look like? I expect the first 10-12 rows should do to give the idea?
  19. Re: Extracting a date from a cell which has a particular value

    But this latest question is a duplicate to https://www.mrexcel.com/forum/excel-questions/1114680-if-cell-contains-text-list-then-return-value-post5369606.html

    Please do not post the same question...
  20. Replies
    5
    Views
    135

    Re: how to simplify nested if

    Well if @4 cannot be anything else (eg blank, "xxx", "R9999" etc) and those 2 blue values you really meant "r12330" and "r1330" then you could certainly create a lookup table and use VLOOKUP as...
  21. Re: Output first Match Found if Cells contain Duplicate Text

    You're welcome. :)

    (And if you would prefer to avoid the C+S+E confirmation, you can use the marginally longer ...)

    <b>Dupes</b><br /><br /><table border="1" cellspacing="0" cellpadding="0"...
  22. Replies
    8
    Views
    8,910

    Re: Concatenate for 100 Cells

    If you have a recent version of Excel you can now do it in one go with

    =TEXTJOIN(",",1,A1:A100)
  23. Replies
    1
    Views
    35

    Re: Capturing Instances

    Still with COUNTIF, like this?

    <b>Countif</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff;...
  24. Replies
    5
    Views
    135

    Re: how to simplify nested if

    I'd be interested to know what values [@4] might be other than those listed: r611, r612, r711 etc
  25. Re: Output first Match Found if Cells contain Duplicate Text

    For a worksheet formula approach, try this array formula (requires Excel 2013 or later). It should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4