• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    Index, Match, Sumifs

    Hi: May be this? Thanks
  2. N

    Running Total -Pivot Table

    Hi May be this? Thanks
  3. N

    Scrape data single URL multiple pages with Power Query

    Hi: I believe if you pay for the service they will give you the APIs needed for these tabs unless you get the REST APIs for these tabs it cannot be extracted as these are separate tables. Thanks
  4. N

    XY Scatter plot (line is crooked)

    Hi: Un-check the smoothed line option.
  5. N

    Scrape data single URL multiple pages with Power Query

    Hi: Find the attached, I have written a function to paginate through all the pages in API connection. Thanks Nebu
  6. N

    Lookup value in column based on criteria

    Hi: Formula highlighted in yellow. Thanks
  7. N

    Overlay of normal distribution curve

    HI: May be something like this? Thanks
  8. N


    Hi: May be create a reference table and do a look up. Thanks
  9. N

    Formula is not giving correct answer

    Hi: Should this be your formula?
  10. N

    Array formula needed. Example sheet

    Hi: May be this using Power Query. Thanks
  11. N

    Power Query group by

    Hi: In the power query editor, select all the columns you want to group and click on the "Group-by" option from the menu. This will group all the selected columns at once. Thanks
  12. N

    How do execute a dynamic formula showing a list of invoice numbers in sequence

    Hi: May be this using power query. Thanks
  13. N

    Conditional Formula

    Hi: May be this? Thanks
  14. N

    Creating a list

    Hi: Solution using power query. Thanks
  15. N

    If > 10 and if < 10 formula

    Hi: May be this? =IF(B2>10,(10*(A2*1.5))+(B2*(A2*2)),B2*(A2*1.5)) Thanks
  16. N

    Unique Values from 2 Columns of a table to an array

    Hi: Codes added for unique records. Thanks
  17. N

    Unique Values from 2 Columns of a table to an array

    Hi: Since I had worked on a similar request here is VBA code for this. Sub blah() Dim tbl As ListObject Set tbl = Me.ListObjects("Table1") i& = Me.Cells(Rows.Count, "A").End(xlUp).Row With tbl.Sort .SortFields.Clear .Header = xlYes .SortFields.Add...
  18. N

    Running Total base on Column values

    Hi: Find the attached. Formula in Green column. Thanks
  19. N

    Running Total Calculation

    Hi: Sheet 8 using power query and power query functions, there is no need to use Power Pivot. I guess Power query is a native function in Excel 2016. Just change your base data in excel spreadsheet and refresh the pivot in sheet 8 the pivot should update with new information. Thanks
  20. N

    Highlight Duplicated lines with multiple conditions

    Hi: There are two options - Use the file I uploaded as a template and transfer your data to the file I created - Copy the macro to the VBA Editor of the sheet where you have your data stored. It is a simple process if you know the basics of VBA. The error will be happening because the sheet...
  21. N

    Running Total Calculation

    @dgoscinski Add your data to the data model, if you are using latest version of excel follow the screenshot below. Once you add your data to the data model as above you will be taken to the following screen Click on the "Design" Tab highlighted in the above snapshot and select the Date...
  22. N

    Running Total Calculation

    Hi: Using Power Pivot and Data Models. Thanks