May 23 2022 04:06 AM
Is there a formula that can put the numbers in a table in the last row of the different table? (no VB)
May 25 2022 02:33 AM
could you please provide an example of what you want to achieve?
At least some screenshots would help.
May 27 2022 12:45 PM
May 30 2022 06:29 AM
I'm sorry, but it's still confusing for me. Could you please upload an example of your file?
Or at least some screenshots where I could see which information should go where under which conditions.
May 30 2022 07:35 AM
I tried to show my meaning in the photo
substations are not accurate , so I want to use the functions for entering numbers
May 30 2022 08:41 AM
Solution
thanks for the screenshots, this is much better. So, it looks like what we call T-accounts, where you put something on the debit side and something on the credit side.
There is probably an easy solution if you use Microsoft 365 / Office 365 (and Excel 2021), because there you have the new dynamic array functions like FILTER.
I tried to rebuild a small example, I have also attached the example file:
So in the above example, the formula in A14 would be:
=IFERROR(FILTER(A2:A8;C2:C8=A12);0)
The surrounding IFERROR just avoids that you get #KALK-errors if an account name is not found.
Just note, that depending on your regional local settings you might need to replace ; with ,
So
=IFERROR(FILTER(A2:A8,C2:C8=A12),0)
The bad news is, that this FILTER-function is not available in older Excel versions before Excel 2021. In this case, I do not have a solution for you, unfortunately.
May 30 2022 08:59 AM
May 30 2022 08:41 AM
Solution
thanks for the screenshots, this is much better. So, it looks like what we call T-accounts, where you put something on the debit side and something on the credit side.
There is probably an easy solution if you use Microsoft 365 / Office 365 (and Excel 2021), because there you have the new dynamic array functions like FILTER.
I tried to rebuild a small example, I have also attached the example file:
So in the above example, the formula in A14 would be:
=IFERROR(FILTER(A2:A8;C2:C8=A12);0)
The surrounding IFERROR just avoids that you get #KALK-errors if an account name is not found.
Just note, that depending on your regional local settings you might need to replace ; with ,
So
=IFERROR(FILTER(A2:A8,C2:C8=A12),0)
The bad news is, that this FILTER-function is not available in older Excel versions before Excel 2021. In this case, I do not have a solution for you, unfortunately.