Posts by mrgramm

Thank You.

I only have one column and each row is different. Each record contains a line with a number. Number of lines per record vary.

Data is downloaded in a single column.

Each record ends with a number. With excel formula I can give each line of each record a grouping number.

Can not seem to replicate it in power query. IF(ISNUMBER(A2),C2+1,C2).The above M code will put a 0 in the first row and then error.

I have attached a worksheet with the query.

I could add the grouping column before starting the query but I would rather not.

Thanks for any help you can give.

Sample Power Query.xlsx

Sample Reconcile .xlsm

Try this macro.

I put the data set on the same page as the criteria for ease of writing formula.

This sumproduct formula worked for me.

=SUMPRODUCT((C4:C7=C17)*(TEXT(D3:M3,"mmm")=D17)*D4:M7)

Enter as an array. Ctrl+Shift+Enter.

Have a table in my workbook called Payee. Workbook all of a sudden started closing when a line was added to Payee table. I created a new Payee sheet and copied just the values from the old sheet. It works fine until the workbook is saved and closed. When opened it will crash when a new line is added to Payee table. All the other sheets and table work fine. Check Book Template.xlsm