Forum

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...

Can you supply a dummy file that is representative of your issue so that we can work with your data types.

Post your entire Mcode for analysis.

Nesha Your picture is exactly what I get when I wish to import your PDF. Click on the Select multiple tables and then select them. This will gen th...