Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    8
    Views
    166

    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...
  2. Replies
    8
    Views
    166

    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;...
  3. Replies
    4
    Views
    97

    Re: Struggle with MID Function

    Hi,

    Another way:

    =IF(OR(LEFT(Y12,2)={"DC","CP"}),Y12,"")
  4. Re: Formula to show whether invoice is paid AND/OR approved

    You're welcome, welcome to the forum, and thanks for the feedback.
  5. Re: Vlookup after LEFT, TRIM and still receiving ERROR

    Not sure who's formula you're referring to, but just want to point out, formula posted in Post # 6 will fail for Single Word or more than 2 word Vessel names since it relies on the 2nd CHAR(160),...
  6. Re: Vlookup after LEFT, TRIM and still receiving ERROR

    Hi,

    Formula in Sheet 1 I4 copied down:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  7. Re: Formula to show whether invoice is paid AND/OR approved

    Then, try this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  8. Replies
    15
    Views
    290

    Re: Total Empty column between two characters

    You're welcome.
  9. Re: Formula to show whether invoice is paid AND/OR approved

    Hi,

    Would there be an instance where, for example, C6 has a date, but C7 does not, what would be the result then?
  10. Replies
    4
    Views
    93

    Re: Add character to the end of a string

    Hi,

    Does this help:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  11. Re: SUM ignoring text fields in a non-string of cells

    If you may have ERRORs (mixed with Text and Numbers) in range, you can use SUMIF:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  12. Re: SUM ignoring text fields in a non-string of cells

    Hi,

    SUM function Ignores non-numeric values in range:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  13. Re: Populating a Cell Based Off of Two Columns Values

    You're welcome, welcome to the forum, and thanks for the feedback.
  14. Thread: Exact function

    by jtakw
    Replies
    5
    Views
    131

    Re: Exact function

    You're welcome, thanks for the feedback.
  15. Replies
    7
    Views
    201

    Re: Running Numbers Formula

    Hi,

    If I understand correctly, you don't need any formula for what you want.

    With AD-01 in A2, Select A2, Left click and hold down on the cell Fill handle (little square in lower right corner...
  16. Thread: Exact function

    by jtakw
    Replies
    5
    Views
    131

    Re: Exact function

    Hi,

    Is this what you mean:

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

    Re: Sumproduct with a lookup nested inside

    You're welcome, thanks for the feedback.
  18. Re: Populating a Cell Based Off of Two Columns Values

    Hi,

    Sounds like you just need SUMIF.

    Use this with the criteria hard coded:

    =SUMIF(K2:K259,"Custom",AT2:AT259)

    Use this with a cell reference for the criteria, you can change A1 to...
  19. Replies
    6
    Views
    127

    Re: ISBLANK question conditional formatting

    You're welcome.
  20. Replies
    15
    Views
    290

    Re: Total Empty column between two characters

    Here's the modified version my formula from Post # 8 that will handle both versions of your data in Post # 1 and # 10, whether or not the data starts with Blanks or Numbers in A2:

    <b></b><table...
  21. Replies
    6
    Views
    127

    Re: ISBLANK question conditional formatting

    Hi,

    Start at D3 and select your range (I.e. D3:D54), CF, use formula, enter:

    =AND(D3<>"",D3< TODAY())

    Format Fill/Font as desired.
  22. Replies
    3
    Views
    89

    Re: Sumproduct with a lookup nested inside

    Hi,

    You really don't need SUMPRODUCT or a Lookup Table if there's only two variables (i.e. Weekly, Monthly):

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  23. Replies
    15
    Views
    290

    Re: Total Empty column between two characters

    Not sure why, but just swap out the "A" with "zzz" like below:

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

    Re: Total Empty column between two characters

    Hi,

    Here's another way:

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

    Re: Compare lists by partial match

    Hi,

    Select the range in Table 2 you want CF applied.
    CF, use Formula, enter:

    =ISNUMBER(LOOKUP(2,1/SEARCH(A$2:A$4,A7)))

    Select Format fill/font as desired.

    Change/adjust A$2:A$4 according...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4