Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Reversing a String of numbers or text with delimiters

    is that what you want?


    rawResult

    10990. 99909990. 10990

    8990. 7990. 8490. 74907490. 8490. 7990. 8990

    1299012990
  2. Replies
    2
    Views
    93

    Re: Compare and count from multiple sheets

    with Power Query aka Get&Transform


    Label1Label2Label3LabelCategoryCategoryCount


    12345
    12345
    12345
    12345AA
  3. Re: How do you query in excel? What would be the best program to complete this in?

    or use Power Query aka Get&Transform


    What is PowerQuery
    Getting started with PQ
    PowerQuery Help
    PowerQuery M reference
  4. Re: Simple question in regard to pivot table

    - sum of Amount
    - Value Field Settings
    - Number format
    - set Number (with decimals or without decimals)
  5. Replies
    6
    Views
    90

    Re: Split the Number

    maybe Text to columns?
  6. Re: Cannot see individual dates in Pivot Table (gets grouped to months automatically)

    Excel Options - Advanced - Data - Disable automatic grouping of Date/Time columns in Pivot Table (checked)
    then re-create PT
  7. Re: Power Query: Removing duplicate values in Multi-Value Cells

    you are welcome

    maybe time to learn more about PowerQuery


    What is PowerQuery
    Getting started with PQ
    PowerQuery Help
    PowerQuery M reference
  8. Re: Power Query: Removing duplicate values in Multi-Value Cells

    Change source range to table (Ctrl+T), - be sure the name of the table is the same as in the code - in this case : Table1
    then use From Table (Get&Transform part on the ribbon)
    then open Advanced...
  9. Replies
    1
    Views
    50

    Re: Cannot filter by months in Pivot Table

    maybe:
    Report Layout - Show in tabular form
    then filter by month
  10. Re: Power Query: Removing duplicate values in Multi-Value Cells

    try


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"Column1"}, {{"Count", each _, type table}}),
    List =...
  11. Replies
    20
    Views
    1,036

    Re: Power Query column alignment

    you are welcome

    use solution with Parsed JSON, much easier and faster (with whole 5 GB file)

    have a nice day
  12. Replies
    3
    Views
    260

    Re: Calculation of Net Working days

    look at few posts later
    there is networkdays with hoildays
  13. Replies
    3
    Views
    260

    Re: Calculation of Net Working days

    see: Networkdays
  14. Re: Can someone help me with this? Probably a beginner level formula.

    worth to read:

    PowerQuery aka Get&Transform (links):

    What is PowerQuery
    Getting started with PQ
    PowerQuery Help
    PowerQuery M reference
  15. Re: Getting Power Query to add new values to the bottom

    you are welcome

    have a nice day
  16. Re: Can someone help me with this? Probably a beginner level formula.

    nothing wrong :)

    all what you need is Append all single tables into one (Power Query) then create Pivot Table
  17. Re: Can someone help me with this? Probably a beginner level formula.

    I give up :diablo:

    Have a nice day
  18. Re: Can someone help me with this? Probably a beginner level formula.

    or Power Query :) :) :)
    or even Power Pivot
  19. Re: Can someone help me with this? Probably a beginner level formula.

    all your needs from the first post to now you can do in just PivotTable

    enough to read about: Pivot Table and some more links there.

    or even change your range to Excel Table (Ctrl+T) , add...
  20. Re: Can someone help me with this? Probably a beginner level formula.

    I'll ask again: what about PivotTable?
  21. Re: Can someone help me with this? Probably a beginner level formula.

    did you try a PivotTable?
  22. Replies
    6
    Views
    127

    Re: Match Function Problem

    sure

    What is PowerQuery?
  23. Replies
    6
    Views
    127

    Re: Match Function Problem

    IMHO PowerQuery (Get&Trannsform) would help
  24. Re: Combining 2 lists (for each cell in first list assign all cells in second list)

    you are welcome

    have a nice day
  25. Re: Combining 2 lists (for each cell in first list assign all cells in second list)

    or with PowerQuery aka Get&Transform


    table1table2table1table2

    austinappleaustinapple

    justinbananaaustinbanana

    paulorangeaustinorange
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4