Last seen: Aug 30, 2025
Use this line of code to filter the RowData based on a list. Table.SelectRows(#"Changed Type", each List.Contains (GLTotals, [RowData])) Read mo...
Like so? See attached.
Just wondering why List.Numbers is needed. You can add a column like: List.Transform( {[Start]*10 .. [End]*10}, each _ / 10 )
If you could attach a file (not just an image) it'll be easier to help.
Depending on the Excel version that you are using one or both formulas in the attached file should work.
I have added three possible solutions to your file. Depending on the Excel version you are using, these may or may not work for you. And as often is t...
No! Sorry.
I'd say you need to find a different calculation. Perhaps the attached file helps you on your way. If not please clarify your intentions. You still ha...
Currently Column G conditionally sums values from Column H. In turn, Column H depends on the value in column G in cases where the second IF is evalua...
Perhaps the mock-up based on your example helps you on your way in your real file. If not, please do as Mynda suggested.
I believe you are struggling with calculating durations where end times may go beyond midnight. Since you are adding 1 to certain values in the formul...
Not sure what you are asking but perhaps the formulas in column M do what you need. If not, come back with some clarification.
When you enter 0018 in a 'General' formatted cell, Excel ignores the leading zeroes. In such a case, the formula joins an empty string with ":18" K...
Great!! Glad I could help. R
I'm confident that it will work