aggregating

  1. B

    group by function in power query

    hello, I have loaded and converted over 300 text files in power query Excel 2016. Now I have about 1M lines that I am trying to do an aggregation on sum and count based on 2 criterias. I am running into some performance issues, it shows that my file is loading data for the last half hour but...
  2. B

    vba code to aggregate data selection from checkboxes into listbox

    I am at a loss for how to do this. My current code is simple and displays data only for the latest checked box: Private Sub ComboBox1_Change() End Sub Private Sub CheckBox1_Change() Me.ListBox1.RowSource = "Sheet2!A22:A32" End Sub Private Sub CheckBox2_Change() Me.ListBox1.RowSource =...
  3. M

    Need to Pull Data from Named Ranges in Separate Workbooks

    I have several workbooks in a folder. Each has a transaction worksheet and a summary worksheet. The number of rows of data in each summary sheet differ from workbook to workbook but all fall within a dynamic range having the name "AData". I would like to consolidate those summary records into a...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top