Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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. 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. 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. 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. 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. Replies
    6
    Views
    334

    Re: Extract multiple strings from 1 cell

    Write this formula in B2:
    =TEXTJOIN(",...
  7. Thread: Sheet Names

    by Jborg
    Replies
    2
    Views
    154

    Re: Sheet Names

    Steve the Fish

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

    I appreciate your fast response.
  8. Thread: Sheet Names

    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. Replies
    6
    Views
    441

    Re: sumif be by categories

    Nice one Pete. Just Beautiful!!! :)
  10. 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. 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. 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. 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 :)
  14. Thread: Pivot table

    by Jborg
    Replies
    2
    Views
    141

    Re: Pivot table

    Thanks.

    You have been very Haplful :)
  15. Thread: Pivot table

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

    Thanks in advance for your help.
  16. Replies
    22
    Views
    842

    Re: Formula to transpose data

    Yes. I did. Thanks :)
  17. Replies
    22
    Views
    842

    Re: Formula to transpose data

    Yes Formula starts in C12. Sorry for the mix-up.
  18. 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. 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. Replies
    22
    Views
    842

    Re: Formula to transpose data

    Hi pete,

    i think he adjusted the column part:
    ...
  21. 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. 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
    ...
  23. Thread: Power Query

    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....
  24. Thread: Microsoft Office

    by Jborg
    Replies
    5
    Views
    443

    Re: Microsoft Office

    Thanks Guys :)
  25. Thread: Microsoft Office

    by Jborg
    Replies
    5
    Views
    443

    Re: Microsoft Office

    What is the difference between office 365 pro plus and office 365 professional plus??
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4