# Search results

1. ### Index, Match, Sumifs

Hi: May be this? Thanks
2. ### Running Total -Pivot Table

Hi May be this? Thanks
3. ### 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. ### XY Scatter plot (line is crooked)

Hi: Un-check the smoothed line option.
5. ### 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. ### Lookup value in column based on criteria

Hi: Formula highlighted in yellow. Thanks
7. ### Overlay of normal distribution curve

HI: May be something like this? Thanks
8. ### Appreciate your help: With VLOOKUP or INDEX or MATCH type of return value .

Hi: May be this? Thanks
9. ### TEXT=%

Hi: May be create a reference table and do a look up. Thanks
10. ### Formula is not giving correct answer

Hi: Should this be your formula?
11. ### return amount/value under specific cell(month) based on calculation and frequency - VBA or EXCEL

Hi: May be this? Thanks
12. ### Array formula needed. Example sheet

Hi: May be this using Power Query. Thanks
13. ### 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. ### How do execute a dynamic formula showing a list of invoice numbers in sequence

Hi: May be this using power query. Thanks
15. ### Conditional Formula

Hi: May be this? Thanks
16. ### Creating a list

Hi: Solution using power query. Thanks
17. ### 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
18. ### Lookup totals by the months going across the spreadsheet

Hi: May be this? Thanks
19. ### Unique Values from 2 Columns of a table to an array

Hi: Codes added for unique records. Thanks
20. ### 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...
21. ### Running Total base on Column values

Hi: Find the attached. Formula in Green column. Thanks
22. ### 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
23. ### 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...
24. ### 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...
25. ### Running Total Calculation

Hi: Using Power Pivot and Data Models. Thanks