Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    Rick, I'll be using both UDF'S. The batch string has 2 4 character word or numbers so it will help me get the second word or number. The other UDF will be for strings that don't have batch.

    The...
  2. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    Peter_SSs, duly noted about providing more concrete examples. It probably is a good idea to provide examples that are closer to the type of data you use at work. Thanks for the tip.
  3. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    I tried these formulas and UDF at work and they work great. Marcelo, the formula works excellent. It is pulling the correct text string even with embedded spaces.

    Rick, I also used your UDF and it...
  4. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    I was just trying to provide a real life example using batch instead of z. What I'm trying to do with this formula is to get a 4 digit check number that comes after batch. I think the formulas and...
  5. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    Thanks for the explanation. So really there is no formula solution.
    With the UDF can you use to select different length characters. So instead of 4, you can select 5?
  6. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    Hello, thanks so much for the help here.
    What do you mean by embedded space?
  7. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    Quote tags didn't work properly. Here is the result?
    Sheet2


    <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 89px"> <col style="WIDTH: 64px"></colgroup> <tbody>
    ...
  8. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    Hello everyone thanks so much.
    It's always a space after the "z" in this example.

    Will the formula change?

    I should give my real world example. My start number is not a character, it's a word....
  9. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    I should have been more clear with my explanation and examples. I'm looking for the first 4 character word or number that starts at z.
    Sheet1


    <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT:...
  10. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    I want to find the 4 character string that starts at z. Here is an example:
    Sheet1


    <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 144px"> <col style="WIDTH:...
  11. Replies
    45
    Views
    1,682

    Re: Extract 4 character string

    Thank you. It works fantastic. To the point that mikerickson made, if I wanted the start character to be z is there a way to do that?

    abc 1034 rtyidf z 7896
    <tbody>...
  12. Replies
    45
    Views
    1,682

    Extract 4 character string

    I'm trying to extract a 4 character string that can be numbers or a text string. Here is the example.

    Sheet1


    <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH:...
  13. Replies
    8
    Views
    407

    Re: Multi Criteria using Seach in a range

    Thank you so much. It works great. It's a very robust and flexible formula that can be tailored to many different situations. Didn't know Excel could do stuff like this. Once again thank you.
  14. Replies
    8
    Views
    407

    Re: Multi Criteria using Seach in a range

    Absolutely brilliant. This formula is more powerful and dynamic than the one I gave you. Never seen anything like it.
    Sometimes my search criteria list will be arranged horizontally.
    Is there a...
  15. Replies
    3
    Views
    620

    Re: Advanced Filter Wildcard using Formula

    Fantastic. This really helps. I spent a few hours today trying to figure this out. This will save me a lot of time at work. Thank you. :)
  16. Replies
    3
    Views
    620

    Advanced Filter Wildcard using Formula

    I'm able to use advanced filter with wildcards that are values only.
    How do you use wildcard advanced filter using a formula.

    Sheet3


    <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold">...
  17. Replies
    8
    Views
    407

    Re: Multi Criteria using Seach in a range

    Thank you so much. The formula works great.:)
    I was trying to use the other formula below since you can use one search function for multiple criteria. So "House"=1 and "Car"=2 so the total is equal...
  18. Replies
    8
    Views
    407

    Multi Criteria using Seach in a range

    I am trying to do a search that is returning the incorrect result. Here is the data.

    Sheet1


    <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 164px"> <col...
  19. Replies
    3
    Views
    276

    Re: Use formula for range and not row

    I think the sumproduct is creating the issue because it can't handle arrays.

    Is there any solution to this?
  20. Replies
    3
    Views
    276

    Re: Use formula for range and not row

    I was trying to use this formula:
    =SMALL(IF(SUMPRODUCT(NOT(ISERR(SEARCH({"smith","paul","greg"},$B$1:$B$4)))*{1,2,4})=7=TRUE,ROW($B$1:$B$4)),1)
    but I'm still getting zero. The result that I want is...
  21. Replies
    3
    Views
    276

    Re: Use formula for range and not row

    The result is row 4 or 4.
  22. Replies
    3
    Views
    276

    Use formula for range and not row

    I got this great formula from Exceluser.com (thank you Charley Kyd) to do multi search criteria.
    Sheet1


    <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 97px"> <col...
  23. Re: Advanced Filter with Array formula wildcard

    I should've been more clear about the question I have.
    Can I use this array formula with advanced filter or do I need another formula?
  24. Advanced Filter with Array formula wildcard

    I have a formula that looks for a certain word within a text string in multiple columns.
    small(if(not(iserror(search("house", B2:E50))),row(B2:E50)),rows($A1:A1)).
    This gives me the row number. ...
  25. Replies
    2
    Views
    359

    Re: Duplicates True/False with errors

    Thank you so much. It works great.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4