Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    6
    Views
    325

    Re: How to pick 1st word

    You're welcome.
  2. Replies
    6
    Views
    242

    Re: Text Contains one of many Things

    Then you can just use my formula in Post # 4 as-is.
  3. Replies
    6
    Views
    325

    Re: How to pick 1st word

    Hi,

    If the 1st word is Always defined before the 1st space:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  4. Replies
    6
    Views
    242

    Re: Text Contains one of many Things

    Hi,

    Try this, normally entered:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  5. Thread: Lookup Help

    by jtakw
    Replies
    2
    Views
    126

    Re: Lookup Help

    Hi,

    Assuming your data page End Date column is in ascending order:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse:...
  6. Re: Formula to search for most previous match?

    Hi,

    F2 formula copied across to H2, and down as far as needed:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse:...
  7. Replies
    7
    Views
    253

    Re: Two Substitute Formulas in one cell

    You're welcome, thanks for the feedback.

    I'd like to make an improvement to my B3 formula in Post # 5 as follows:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  8. Thread: Date in string

    by jtakw
    Replies
    16
    Views
    516

    Re: Date in string

    Hi,

    According to you description:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  9. Replies
    7
    Views
    253

    Re: Two Substitute Formulas in one cell

    B3 formula will work for any number of words:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  10. Replies
    7
    Views
    253

    Re: Two Substitute Formulas in one cell

    Hi,

    Since you only gave 1 sample...if it's Always 4 words separated by commas, then use this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border:...
  11. Replies
    4
    Views
    201

    Re: countif within range

    Hi,

    Michael's formula in Post # 2 didn't display properly, it should have been:

    =SUMPRODUCT((B2:L15< BX5)*(B2:L15>CA5))

    and here's another option for you:
    ...
  12. Replies
    8
    Views
    355

    Re: I hope this can be done?

    Hi,

    Perhaps this might also help:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  13. Re: return text after 2nd occurrence of an equal sign (=)

    Hi,

    If, according to your description, you don't care for the Order of the data (i.e. Width, Depth, Height), you Just want the 1st, 2nd, and 3rd numeric values extracted, use this in Column H,...
  14. Replies
    11
    Views
    295

    Re: Need formula t0 extract # between ()

    You're welcome, thanks for the feedback.

    Just realized the LEFT function isn't needed in my formula from Post # 5, can be just:

    <b></b><table cellpadding="2.5px" rules="all"...
  15. Re: Search row for keyword and build a new table with values

    Just realized my B Column formula from Post # 3 can be written shorter, either B6 or B7 below:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  16. Replies
    11
    Views
    295

    Re: Need formula t0 extract # between ()

    Hi,

    Another option:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  17. Re: Search row for keyword and build a new table with values

    Hi,

    Another way, all formulas normally entered:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  18. Re: Formula merging a countif with a second if statement

    Hi,

    Almost the same as Dante's:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  19. Re: Searching Field for Contents of Named Range

    If that's the case, assuming you're Only trying to match Whole words or Phrases in LeadershipTitles against K5, try either of the following:

    =SUMPRODUCT(--ISNUMBER(SEARCH(" "&LeadershipTitles&"...
  20. Replies
    9
    Views
    369

    Re: Formula deduction

    You're welcome, welcome to the forum, and thanks for the feedback.
  21. Re: Searching Field for Contents of Named Range

    Hi,

    A couple of things:

    1. You have your SEARCH criteria backwards, right now you're searching LeadershipTitles within K5, and the 8th one down the list is COO, which IS part of Sales...
  22. Replies
    4
    Views
    162

    Re: Countifs with Or tidy-up

    Hi,

    Try also this:

    =SUM(COUNTIFS(DatesWork!$C$2:$C$3000,"GATED",DatesWork!$G$2:$G$3000,{"01/01/1900","#","No Date"}))
  23. Replies
    9
    Views
    369

    Re: Formula deduction

    Doesn't look like you've tried my formula in Post # 3 yet, but it seems like you want K2 to show 0 when M2 is Blank ( which was not in the description in your OP ), modified below, is this what you...
  24. Replies
    9
    Views
    369

    Re: Formula deduction

    Hi,

    If I understand correctly, use this in K2 copied down.

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  25. Replies
    4
    Views
    156

    Re: Struggle with MID Function

    Hi,

    Another way:

    =IF(OR(LEFT(Y12,2)={"DC","CP"}),Y12,"")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4