# Search:

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

Page 1 of 6 1

## Search: Search took 0.08 seconds.

by jtakw
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...

by jtakw
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. ## Thread: Struggle with MID Function

by jtakw
Replies
4
Views
97

### Re: Struggle with MID Function

Hi,

Another way:

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

by jtakw
Replies
5
Views
125

### Re: Formula to show whether invoice is paid AND/OR approved

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

by jtakw
Replies
10
Views
159

### 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. ## Thread: Vlookup after LEFT, TRIM and still receiving ERROR

by jtakw
Replies
10
Views
159

### 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. ## Thread: Formula to show whether invoice is paid AND/OR approved

by jtakw
Replies
5
Views
125

### 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. ## Thread: Total Empty column between two characters

by jtakw
Replies
15
Views
290

### Re: Total Empty column between two characters

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

by jtakw
Replies
5
Views
125

### 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?

by jtakw
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. ## Thread: SUM ignoring text fields in a non-string of cells

by jtakw
Replies
13
Views
168

### 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. ## Thread: SUM ignoring text fields in a non-string of cells

by jtakw
Replies
13
Views
168

### 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. ## Thread: Populating a Cell Based Off of Two Columns Values

by jtakw
Replies
3
Views
90

### Re: Populating a Cell Based Off of Two Columns Values

You're welcome, welcome to the forum, and thanks for the feedback.

by jtakw
Replies
5
Views
131

### Re: Exact function

You're welcome, thanks for the feedback.
15. ## Thread: Running Numbers Formula

by jtakw
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...

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. ## Thread: Sumproduct with a lookup nested inside

by jtakw
Replies
3
Views
89

### Re: Sumproduct with a lookup nested inside

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

by jtakw
Replies
3
Views
90

### 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. ## Thread: ISBLANK question conditional formatting

by jtakw
Replies
6
Views
127

### Re: ISBLANK question conditional formatting

You're welcome.
20. ## Thread: Total Empty column between two characters

by jtakw
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. ## Thread: ISBLANK question conditional formatting

by jtakw
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. ## Thread: Sumproduct with a lookup nested inside

by jtakw
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):

23. ## Thread: Total Empty column between two characters

by jtakw
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. ## Thread: Total Empty column between two characters

by jtakw
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. ## Thread: Compare lists by partial match

by jtakw
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.