Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Thread: text to time

    by sandy666
    Replies
    5
    Views
    43

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

    by sandy666
    Replies
    5
    Views
    43

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

    by sandy666
    Replies
    5
    Views
    43

    Re: text to time

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

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

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

    maybe


    UniqueIDValueUniqueIDValueCustom

    42787_Bailey_a
    342787_Bailey_a
    3
    1
  11. 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
  12. Replies
    1
    Views
    48

    Re: Update cell based of powerquery result

    do everything with PowerQuery
  13. Replies
    3
    Views
    120

    Re: Sumifs and array question

    maybe PowerQuery aka Get&Transform


    ProjectValueTitleHoursTitle2Hours3Title4Hours5Value.1Sum


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

    remove top rows: 1
    promote
  15. Replies
    3
    Views
    193

    Re: Does Access support pivot tables now

    You are welcome, thanks for the feedback
  16. 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...
  17. Re: Pivot Table Filter For Multiple Survey Responses

    so choose the post you want :)
  18. Re: Pivot Table Filter For Multiple Survey Responses

    like this one?


    Teacher(All)

    AttributeQ1



    Count of ValueGrade
  19. Re: Pivot Table Filter For Multiple Survey Responses

    or this


    Teacher(All)



    Count of ValueGradeValue
  20. Re: Pivot Table Filter For Multiple Survey Responses

    something like this?


    Teacher(All)



    Sum of ValueGrade

    Attribute
  21. Re: Pivot Table Filter For Multiple Survey Responses

    file is NOT shared
  22. Replies
    3
    Views
    193

    Re: Does Access support pivot tables now

    maybe it will help: PivotTable in Access2010 or Access2013
  23. Replies
    3
    Views
    107

    Re: SQLITE Integration

    You are welcome

    there is export to Excel, CSV and some more...

    Have a nice day
  24. Replies
    3
    Views
    107

    Re: SQLITE Integration

    maybe SQLite2009 Pro 3.8 (free)
  25. Re: Power Query Does Not Import Multiple PDF Pages

    You are welcome

    Impatient person :laugh:

    have a nice day
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4