every month I am getting the report with invoices’ numbers, amounts etc. I need to manually check if that invoice was sent to me via email and if so – is the amount on the invoice correct with what I have on a report.

I have an excel formula in column D below using this formula.

My input table is the two orange columns and I’m trying to create the three blue ones :

I’m attempting to split a table in Excel based on rows using Power Query. Specifically, I want to create a separate table for “NON-CURRENT ASSETS”.
my data

I’m practically new in Power Query, I did some simple queries in the past, but I’m trying to make a dinamyc one to proccess the data in a table to calculate the percentage distribution of the absolutes and this is what I have so far…

I have a table generated via a query that I’m trying to add a “Comment” column all the way to the right. I was doing this by creating a Self-Referencing query, and then merging them in the original query, as per this video https://www.youtube.com/watch?v=wHgv_gWw7iQ. I have around 3700 rows, and when I merge them, I end up with something like 5400. So not a doubling up of everthing. I watched this video https://www.youtube.com/watch?v=abfXF-WPW7A, and, “yes” this recursion thing happens to me too, although, as mentioned, not a doubling. Also, filtering out the table doesn’t help anyway.

My input is a table :

I have a power query that pulls a list of files in a folder on my windows machine. I have to review these files, and somehow mark off when these files have been reviewed (so I can go back into the spreadsheet on the next day and know where I have left off). I’d prefer that this be done dynamically.

I have a power query that when using the Power Query editor, shows error if bad data is entered in a spread sheet. however when this query is added to a sheet, it just shows blank. Id prefer it show Error to give user feedback that something is wrong and likely they need to check their inputs. Googling hasnt revealed how to do this.

i want to query external data into excel, meanwhile the file should be shared so several people could edit at same time, power query can’t be used in shared file, is there any other excel build-in function could achieve?