Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Extracting out specific text from within a cell

    with your example you can try PowerQuery aka Get&Transform


    RAWRAW.1RAW.2.1Custom

    1 oz Eau De Toilette Spray1ozEDT

    1.6 oz EDT Spray1.6ozEDT

    3.4 ml Eau De Cologne Concentre Spray3.4mlEDC
  2. Replies
    10
    Views
    151

    Re: Index, Match when values the same

    ok, I was just making sure
  3. Replies
    10
    Views
    151

    Re: Index, Match when values the same

    maybe I misunderstood, It MUST be a formula?
  4. Replies
    10
    Views
    151

    Re: Index, Match when values the same

    so maybe someone else will give you formula solution

    have a nice day
  5. Replies
    10
    Views
    151

    Re: Index, Match when values the same

    you can try PowerQuery aka Get&Transform,

    eg.


    Select

    Thu, Oct 24, 2019
  6. Re: Transposing and clearing cells to tidy up data

    You are welcome
    Have a nice day (weekend :) )
  7. Re: Transposing and clearing cells to tidy up data

    So time to learn :)

    more about PowerQuery aka Get&Transform

    What is PowerQuery
    Getting started with PQ
    PowerQuery Help
    PowerQuery M reference
  8. Re: Transposing and clearing cells to tidy up data

    with Power Query aka Get&Transform


    TeamPerson1Person2Person3Person4Person5Person6COUNTTypeNoteDateDayTime

    A,B,C,D,E,FABCDEF6LAB 01computational biology20-Nov-19Wed10:00
    ...
  9. Re: Transposing and clearing cells to tidy up data

    post your raw data and expected result
    or better, post a link to the shared excel file with raw data and expected result
  10. Thread: text to time

    by sandy666
    Replies
    5
    Views
    138

    Re: text to time

    test it: enter time, change format to text, then change format to general then change format to time. don't change format of the cell before entering time

    if you want more use Alt+Q or F1
  11. Thread: text to time

    by sandy666
    Replies
    5
    Views
    138

    Re: text to time

    dbl click and enter is the same as I said: re-enter time (after changing format)

    Excel has many ways to do the same things
  12. Thread: text to time

    by sandy666
    Replies
    5
    Views
    138

    Re: text to time

    do exactly the same, highlight, change format and enter time
  13. Re: Expand data line by line - complicated question

    You are welcome
    I'm happy you are happy :)
    Now you can click on the button Thanks/Like (bottom left corner) in the posts which have helped you
    Have a nice day
  14. Re: Expand data line by line - complicated question

    here is example file
  15. Re: Expand data line by line - complicated question

    so select your source table (range)
    from Data tab choose From Table (or Get Data - From Table), check My Table Has Headers
    it will open Power Query Editor
    go to Advanced Editor
    replace code there...
  16. Re: Expand data line by line - complicated question

    this is NOT vba
    this is Power Query M-code
    what is your Excel version?
  17. Re: Expand data line by line - complicated question

    You can do that with PowerQuery aka Get&Transform


    UniqueIDValueUniqueIDValue

    42787_Bailey_a
    342787_Bailey_a
    1

    42901_Handerson_a
  18. Re: Power Query: Combine Files, delete row1, promote row2 as headers

    I don't see any M function and any parameter, :confused: but if it works for you that's great

    have a nice day
  19. Re: Expand data line by line - complicated question

    maybe


    UniqueIDValueUniqueIDValueCustom

    42787_Bailey_a
    342787_Bailey_a
    3
    1
  20. Re: Power Query: Combine Files, delete row1, promote row2 as headers

    sure but we don't know your wonderful M functions and queries with parameter
  21. Replies
    1
    Views
    74

    Re: Update cell based of powerquery result

    do everything with PowerQuery
  22. Replies
    3
    Views
    147

    Re: Sumifs and array question

    maybe PowerQuery aka Get&Transform


    ProjectValueTitleHoursTitle2Hours3Title4Hours5Value.1Sum


    15BobBob
    44
  23. Re: Power Query: Combine Files, delete row1, promote row2 as headers

    remove top rows: 1
    promote
  24. Replies
    3
    Views
    251

    Re: Does Access support pivot tables now

    You are welcome, thanks for the feedback
  25. Re: Pivot Table Filter For Multiple Survey Responses

    you will need PowerQuery aka Get&Transform

    use Data tab, select whole source table, then on the ribbon From Table, it will open PQ Editor, select all Q columns, from the PQ Editor ribbon choose...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4