Forum

Then you would have to add another SUMIFS statement to the formula that deducts the values for "CC_Refund". I've done that in the attached file in the...

Perhaps the easiest would be to use Table.Split and cut up the larger table into ones with 500 rows. This creates a list of tables, each 500 rows larg...

No problem. Then use this: =D2+IF(OR(B3="Withdrawal",B3="Transfer_Out"),-C3,C3) alternatively, if you only have "Deposit" for all incoming amounts...

You can try this formula in D3 and copy it down: =D2+IF(B3="Withdrawal",-C3,C3)

Since you mentioned having tried XLOOKUP, you should also have FILTER. So, try this as an alternativ: =FILTER(Values[Vol/hr],(Values[Nozzle]=[@Nozz...

I took Phil's file and added a table listing the negative revenue accounts and used that to identify the revenue numbers to be changed. All was done b...

When you look at the query in my file you should be able to follow the steps I took. Not sure what source exactly you found on-line but I just crea...

Hi Francis, Perhaps the PQ example in the attached file will help you on your way. It's a straight-forward Unpivot, Sort and Pivot scenario. Rin...

You can use the following conditional formatting formula for that. =MATCH(I2,$F$2:$F$5,0) and apply it to $I$2:$I$6

Sorry, but I don't understand. Perhaps someone else can help you.

Thanks for the file and sorry for being slow. now you need to try and explain what you want to do with it.

Sorry, but I don't understand. There is no attachment and your question is not clear. At least not to me.

There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.

Alternatively, use Power Query, as shown in the attached file.

Hi, I believe that what you are trying to do might not be covered in the course, but Mynda needs to confirm that. In the attached file, I have a...