Forum

Based upon the info provided then: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, ea...

Phil, That is exactly what I came up with. I am guessing that to get them as Serghi has, we need another column filter on. Thanks very much. You...

Phil, I am curious as to how you would do the same as asked with out regard to the column Account and only total based upon the change in Descripti...

What does adding cells spiraly mean? Attach a file showing us what you are trying to do. Are you trying to Create a Fibonacci Sequence

It appears that the fourth column is the sum of second column based on the grouping of the first column. Is the answer in the fourth column what you ...

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Students", Int64.Type}, {"Year ...

In Power Query, these would be three separate tables and would require three separate queries if you are trying to keep this on one sheet in Excel. I...

Here is a Power Query Solution let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Removed Other Columns" = Table.SelectColumns(Sou...

Rory, Thanks for the code. I got it now. Works Perfectly. Alan

Thanks all. Philip, understand what happened there and tried to get Rory's suggestion on the floating point to work but could not get the syntax to n...

crossposted:

Lea Depending on what version of Excel you are running (I am running 365) there is an option on the Data Tab under Get and Transform Data to paste ...

Here is a Macro solution for Consult which you can adapt for your other counts Option Explicit Sub Lea() Dim i As Long, lr As Lo...

Load (attach) some sample data that is representative (8-10 records per sheet/workbook) of your actual data and we can then demonstrate. NO Pictures...