# Search:

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

Page 1 of 6 1

1. ## Thread: How to pick 1st word

by jtakw
Replies
6
Views
357

### Re: How to pick 1st word

You're welcome.
2. ## Thread: Text Contains one of many Things

by jtakw
Replies
6
Views
262

### Re: Text Contains one of many Things

Then you can just use my formula in Post # 4 as-is.
3. ## Thread: How to pick 1st word

by jtakw
Replies
6
Views
357

### 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. ## Thread: Text Contains one of many Things

by jtakw
Replies
6
Views
262

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

### 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. ## Thread: Formula to search for most previous match?

by jtakw
Replies
5
Views
102

### 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. ## Thread: Two Substitute Formulas in one cell

by jtakw
Replies
7
Views
283

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

### 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. ## Thread: Two Substitute Formulas in one cell

by jtakw
Replies
7
Views
283

### 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. ## Thread: Two Substitute Formulas in one cell

by jtakw
Replies
7
Views
283

### 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. ## Thread: countif within range

by jtakw
Replies
4
Views
209

### 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. ## Thread: I hope this can be done?

by jtakw
Replies
8
Views
391

### 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. ## Thread: return text after 2nd occurrence of an equal sign (=)

by jtakw
Replies
7
Views
220

### 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. ## Thread: Need formula t0 extract # between ()

by jtakw
Replies
11
Views
328

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

15. ## Thread: Search row for keyword and build a new table with values

by jtakw
Replies
7
Views
90

### 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. ## Thread: Need formula t0 extract # between ()

by jtakw
Replies
11
Views
328

### 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. ## Thread: Search row for keyword and build a new table with values

by jtakw
Replies
7
Views
90

### 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. ## Thread: Formula merging a countif with a second if statement

by jtakw
Replies
4
Views
120

### 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. ## Thread: Searching Field for Contents of Named Range

by jtakw
Replies
3
Views
96

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

20. ## Thread: Formula deduction

by jtakw
Replies
9
Views
421

### Re: Formula deduction

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

by jtakw
Replies
3
Views
96

### 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. ## Thread: Countifs with Or tidy-up

by jtakw
Replies
4
Views
177

### 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. ## Thread: Formula deduction

by jtakw
Replies
9
Views
421

### 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. ## Thread: Formula deduction

by jtakw
Replies
9
Views
421

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

by jtakw
Replies
4
Views
173

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