This is a financial account template for 15 years, and the original author is unknown. Very practical, some students are in use. Today, another student who wondered this template, when she was used to find her form, and found the problem and let Lu Zi improve.
In principle, I am not involved in the template made by others, but this original author is unknown, and the student is in a hurry, and the participation is applied.
The contents of the accounting credentials are generated based on the credential number H5, and the auxiliary column M column is used during the operation.
In the actual use process, the voucher is entry into a month, therefore lacks a condition, month. The screening certificate number is 1, and there is a multi-month data, so that the result of the result is wrong.
There are a lot of solutions, which provide auxiliary column practice.
Month and credential numbers are used to connect.
= C6 & “|” & b6
Back to the voucher printing this table, the month can be extracted with MONTH, then use & connection with the certificate number.
= MONTH ($ C $ 4) & “|” & $ h $ 5
Then, the place where you have just changed is settled in the original formula.
= IF (COUNTIF) $ 6: $ k $ 65440, Month ($ C $ 4) & “|” & $ H $ 5) – $ M7> 0, Offset (Credential Enter! $ E $ 5, Match (Month $ C $ 4) & “|” & $ H $ 5, voucher entry! $ K $ 6: $ k $ 65440, 0) + $ M7, 0) & “”, 0)
In the financial work, do you encounter a problem that the focus is not aware of how to solve it?
(Add a small program here, please see the headline client today)
Then, the offset third parameter, the offset column, 0 is changed to 1, so that the general ledger can be obtained.
Similarly, tomorrow subject, 0 change to 2.
https://m.acc5.com/activity/datum?fromlogin=12
The debit amount, 0 is changed to 3. The loan amount is changed to 4. However, the amount involved in the amount is “” removed, or it will become a text format, and it cannot be directly obtained.
Other worksheets, you can also learn from it to see if you can use it in your own work.
Source: Excel does not work overtime
Notice
1. The following reviews: collection, and forward the collection;
2, then click on the small first image, find the private letter function,
Private me reply:
【learn】,
You can receive it for free
Review “Calendar” free 21 years of the latest accounting desk calendar