Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Thread: Subtotal

    by sandy666
    Replies
    3
    Views
    47

    Re: Subtotal

    you are welcome

    have a nice day
  2. Thread: Subtotal

    by sandy666
    Replies
    3
    Views
    47

    Re: Subtotal

    Pivot Table?
  3. 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
  4. Replies
    10
    Views
    176

    Re: Index, Match when values the same

    ok, I was just making sure
  5. Replies
    10
    Views
    176

    Re: Index, Match when values the same

    maybe I misunderstood, It MUST be a formula?
  6. Replies
    10
    Views
    176

    Re: Index, Match when values the same

    so maybe someone else will give you formula solution

    have a nice day
  7. Replies
    10
    Views
    176

    Re: Index, Match when values the same

    you can try PowerQuery aka Get&Transform,

    eg.


    Select

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

    You are welcome
    Have a nice day (weekend :) )
  9. 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
  10. 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
    ...
  11. 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
  12. Thread: text to time

    by sandy666
    Replies
    5
    Views
    141

    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
  13. Thread: text to time

    by sandy666
    Replies
    5
    Views
    141

    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
  14. Thread: text to time

    by sandy666
    Replies
    5
    Views
    141

    Re: text to time

    do exactly the same, highlight, change format and enter time
  15. 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
  16. Re: Expand data line by line - complicated question

    here is example file
  17. 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...
  18. Re: Expand data line by line - complicated question

    this is NOT vba
    this is Power Query M-code
    what is your Excel version?
  19. 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
  20. 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
  21. Re: Expand data line by line - complicated question

    maybe


    UniqueIDValueUniqueIDValueCustom

    42787_Bailey_a
    342787_Bailey_a
    3
    1
  22. 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
  23. Replies
    1
    Views
    74

    Re: Update cell based of powerquery result

    do everything with PowerQuery
  24. Replies
    3
    Views
    147

    Re: Sumifs and array question

    maybe PowerQuery aka Get&Transform


    ProjectValueTitleHoursTitle2Hours3Title4Hours5Value.1Sum


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

    remove top rows: 1
    promote
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4