Good day,
I would like to solve this problem using formula, query, or pivot.
My company is issuing invoices. Most of them charge audit service fee and outlay together, and some of them only charge outlay.
I cannot think of a logic to distinguish them in the format I expected.
Please help.
Service fee and outlay.png
Bookmarks