# Search:

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

Page 1 of 6 1

1. ## Thread: Extract multiple keywords from text string

by Jborg
Replies
94
Views
8,466

### Re: Extract multiple keywords from text string

Hi Pete, hope you are all well. I was answering the original post. :) :)
2. ## Thread: Extract multiple keywords from text string

by Jborg
Replies
94
Views
8,466

### Re: Extract multiple keywords from text string

In C1 =TEXTJOIN(" ",,IFERROR(MID(B1,IFERROR(SEARCH(A1:A4,B1,1),0),LEN(\$A\$1:\$A\$4)),""))
3. ## Thread: Excel Keyboard shortcuts

by Jborg
Replies
0
Views
449

### Excel Keyboard shortcuts

Hi Guys,

I have office 365 insider.

My question is that for Power Pivot the keyboard shortcut should be Alt + B + M.
Instead I have to use Alt + Y4+ M. is there a setting I should do?? can I...
4. ## Thread: Microsoft office Pro plus 2016

by Jborg
Replies
1
Views
531

### Microsoft office Pro plus 2016

Hi Guys, I have installed the Microsoft office professional plus 2016 on my personal computer (with a subscription of course) and i signed for the insider. My question is:
Is it different from the...
5. ## Thread: Help with the basic formula

by Jborg
Replies
4
Views
210

### Re: Help with the basic formula

=IFERROR(INDEX(\$C\$2:\$C\$4,SMALL(IF((\$A\$2:\$A\$4=\$A7)*(\$B\$2:\$B\$4=B\$6)=1,ROW(\$C\$2:\$C\$4)-ROW(\$C\$2)+1),1)),"")

Ctrl + Shift + Enter

Should work
6. ## Thread: Extract multiple strings from 1 cell

by Jborg
Replies
6
Views
334

### Re: Extract multiple strings from 1 cell

Write this formula in B2:
=TEXTJOIN(",...

by Jborg
Replies
2
Views
154

### Re: Sheet Names

Steve the Fish

Thanks Alot. It works like a charm :) :)

by Jborg
Replies
2
Views
154

### Sheet Names

Might be possible with VBA??

I have a workbook with 12 sheets for every Month. Sheet Names are January-2019 etc all the way to December-2019

In every sheet in cell R3 i have written 2019.

Is...
9. ## Thread: sumif be by categories

by Jborg
Replies
6
Views
441

### Re: sumif be by categories

Nice one Pete. Just Beautiful!!! :)
10. ## Thread: finding a wotd in cell and pasting what after it in the required cell

by Jborg
Replies
17
Views
580

### Re: finding a wotd in cell and pasting what after it in the required cell

If your text is in A1 put this formula in B1
=SUBSTITUTE(A1,MID(A1,1,SEARCH(":",A1,1)+1),"")

Is this what you want?
11. ## Thread: Removing Everything before Specific String of Characters

by Jborg
Replies
6
Views
362

### Re: Removing Everything before Specific String of Characters

Assuming that Text is in A1. Put this formula in E1

=SUBSTITUTE(A1,MID(A1,1,LARGE(INDEX(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=".")*(ROW(INDIRECT("1:"&LEN(A1)))),0),2)),"")

This should work...
12. ## Thread: Index, Match (Intersection cell data)

by Jborg
Replies
7
Views
463

### Re: Index, Match (Intersection cell data)

I cannot get the proper ranges in your sample Data.....but the formula is the below:
=INDEX(INDEX(\$H\$4:\$K\$17,,MATCH(\$D\$7,\$H\$3:\$K\$3)),MATCH(\$B\$7&\$C\$7,INDEX(\$H\$4:\$H\$17&\$I\$4:\$I\$17,0),0))

You do not...
13. ## Thread: Count Year within different date formats

by Jborg
Replies
9
Views
173

### Re: Count Year within different date formats

#6
Try putting the 2018 as "2018"

Text function changes the numeric value to text Format.

Not sure if this the solution.....but try :)

by Jborg
Replies
2
Views
141

### Re: Pivot table

Thanks.

You have been very Haplful :)

by Jborg
Replies
2
Views
141

### Pivot table

Hi Guys,

I am current working on a Pivot Table where I have (Blank) in certain columns. Is there a way how to get rid of them???

16. ## Thread: Formula to transpose data

by Jborg
Replies
22
Views
842

### Re: Formula to transpose data

Yes. I did. Thanks :)
17. ## Thread: Formula to transpose data

by Jborg
Replies
22
Views
842

### Re: Formula to transpose data

Yes Formula starts in C12. Sorry for the mix-up.
18. ## Thread: Formula to transpose data

by Jborg
Replies
22
Views
842

### Re: Formula to transpose data

Hi Pete,

The output shown in Cells A12 to A14 is what the formula produces. They may have changed the desired output??
19. ## Thread: Formula to transpose data

by Jborg
Replies
22
Views
842

### Re: Formula to transpose data

Hi Pete,

A12 to A14 123 456 789

Then Put the formula in C12 and drag over and down.
...
20. ## Thread: Formula to transpose data

by Jborg
Replies
22
Views
842

### Re: Formula to transpose data

Hi pete,

i think he adjusted the column part:
...
21. ## Thread: Formula to transpose data

by Jborg
Replies
22
Views
842

### Re: Formula to transpose data

Hi Pete_SSs,

Thanks for pointing it out. However the formula works across columns as you might have seen already. I could not see the end result clearly.

Yes nice to be here. Always learning...
22. ## Thread: Formula to transpose data

by Jborg
Replies
22
Views
842

### Re: Formula to transpose data

It can be done with a formula:

First I listed an original of your numbers starting in cell A12 - 123
A13 - 456
...

by Jborg
Replies
0
Views
275

### Power Query

Hi Guys,

I am using power query to append 14 sheets and i am saving it on DropBox so my Boss can see it. My problem is, that when my boss tries to update himself, all 14 sheets loose the path....

by Jborg
Replies
5
Views
443

### Re: Microsoft Office

Thanks Guys :)