• 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

    Hui...

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

Recent content by Nebu

  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

    Appreciate your help: With VLOOKUP or INDEX or MATCH type of return value .

    Hi: May be this? Thanks
  9. N

    TEXT=%

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

    Formula is not giving correct answer

    Hi: Should this be your formula?
  11. N

    return amount/value under specific cell(month) based on calculation and frequency - VBA or EXCEL

    Hi: May be this? Thanks
  12. N

    Array formula needed. Example sheet

    Hi: May be this using Power Query. Thanks
  13. 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
  14. N

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

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

    Conditional Formula

    Hi: May be this? Thanks
See more
Back
Top