Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    no problem
  2. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    don't quote post if it is not really needed. use Reply instead of Reply With Quote.
    besides, I know what I wrote.
  3. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    read Board FAQ / Guidelines
    or
    post a link to the shared excel file with representative example of source and expected result using OneDrive, GoogleDrive, DropBox or any similar
  4. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    nothing attached
  5. Replies
    3
    Views
    59

    Re: Days and months into quarters

    you didn't show expected result so maybe this with PowerQuery


    DATESQuarter


    01/01/2019
    1
  6. Replies
    3
    Views
    70

    Re: How to group this in Pivot Tables

    you are welcome

    Have a nice day
  7. Re: Consolidating multiple rows into one single row - large data file

    you are welcome

    have a nice day
  8. Re: Consolidating multiple rows into one single row - large data file

    there is no any export
    there is Close&Load and you can choose where your query table will be placed or you can stay with query table as connection
    what you mean by : exported code?
    code, or rather...
  9. Replies
    3
    Views
    70

    Re: How to group this in Pivot Tables

    try with PowerQuery


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    UnPivot = Table.UnpivotOtherColumns(Source, {"Customer Name"}, "Attribute", "Value"),
    ...
  10. Re: Consolidating multiple rows into one single row - large data file

    How you get data into the sheet it's up to you

    if you've data in the sheet just use Ctrl+T (check table name in Name Manager)
    the rest you can do in PowerQuery Editor

    if your table has name...
  11. Replies
    8
    Views
    421

    Re: Insert New Row in Excel Power Query

    sure :laugh:

    have a nice day
  12. Re: Consolidating multiple rows into one single row - large data file

    is that what you want?

    Source:

    Business GroupLast NameFirst NameUNIDEmail AddressQuestionnaire TitleSectionQuestionResponseDate

    AdvisorySmithDavidxxxxxxxxxPropertyDisclosureWhat best...
  13. Replies
    8
    Views
    421

    Re: Insert New Row in Excel Power Query

    Header1Header2Header3Header4

    aabbccdd

    wweerrtt


    with Table.FromRecords
  14. Re: Find 2nd and 3rd highest numbers in a row and return column header

    maybe something like this:


    ETF-AETF-BETF-CETF-DMaxCustom


    30
    6
    30
    30
  15. Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

    maybe it's time to learn PowerQuery? :biggrin:

    anyway, good luck with formula

    Have a nice day
  16. Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

    with PowerQuery aka Get&Transform


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Filter = Table.SelectRows(Source, each ([Status] = "Active" or [Status] =...
  17. Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

    something like this?


    Country CodeShop ID


    4101
    4101002
  18. Replies
    11
    Views
    130

    Re: How to create double vlookup in Excel?

    If you say so...

    Have a nice day
  19. Replies
    11
    Views
    130

    Re: How to create double vlookup in Excel?

    use PowerQuery (Get&Transform) with Merge feature
  20. Re: Why is LOOKUP result changing - sometimes to wrong answer

    but you can post a link to the shared excel file with representative example and expected result using OneDrive, GoogleDrive or any similar
  21. Replies
    10
    Views
    186

    Re: I need with my friend

    maybe:


    A
    B
    C
    D
    E
    F
    G
  22. Replies
    12
    Views
    337

    Re: String Function

    another way with PowerQuery (Get&Transform)


    InputText

    AbST/1234342AST

    Y_sRR/666YRR

    B.RE/1234BRE
  23. Replies
    3
    Views
    72

    Re: Merge/Combine Rows Help

    try PowerQuery (Get&Transform) with Group feature and SUM option for values
  24. Re: Consolidating multiple rows into one single row - large data file

    Sure, I hope this will not be a picture :)
  25. Re: Consolidating multiple rows into one single row - large data file

    without representative example with structure and expected result I can say try PowerQuery with Group feature
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4