Discussion Insert the numbers of a table in the last row of a different table (no VB) in Excel
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3414004#M147611
<P>Is there a formula that can put the numbers in a table in the last row of the different table? (no VB) </P>Mon, 23 May 2022 11:06:54 GMTMRAfshar30002022-05-23T11:06:54ZInsert the numbers of a table in the last row of a different table (no VB)
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3414004#M147611
<P>Is there a formula that can put the numbers in a table in the last row of the different table? (no VB) </P>Mon, 23 May 2022 11:06:54 GMThttps://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3414004#M147611MRAfshar30002022-05-23T11:06:54ZRe: Insert the numbers of a table in the last row of a different table (no VB)
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3426230#M147962
<P>Hi <LI-USER uid="1376380"></LI-USER> </P><P> </P><P>could you please provide an example of what you want to achieve? </P><P>At least some screenshots would help.</P>Wed, 25 May 2022 09:33:15 GMThttps://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3426230#M147962Martin_Weiss2022-05-25T09:33:15ZRe: Insert the numbers of a table in the last row of a different table (no VB)
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3440167#M148395
Consider that the mineral, gold, silver, copper, gypsum, coal and iron mining, and each storage die and fall into the pit. (At the top of each well is written which one it is for) Here is my table from which the information should be extracted and automatically placed in a different and relevant table, unlike the well that is poured the later, the higher the The table is lower. I have the column ABCD and the columns (A and B) are never filled in the same row, and so on (C and D), for example: I have A1 B2 and C1 D2, the word in A1 says Which table should C1 be in and B2 in the same wayFri, 27 May 2022 19:45:14 GMThttps://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3440167#M148395MRAfshar30002022-05-27T19:45:14ZRe: Insert the numbers of a table in the last row of a different table (no VB)
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3445507#M148607
<P>Hi <LI-USER uid="1376380"></LI-USER> </P><P> </P><P>I'm sorry, but it's still confusing for me. Could you please upload an example of your file?</P><P>Or at least some screenshots where I could see which information should go where under which conditions. </P><P> </P>Mon, 30 May 2022 13:29:52 GMThttps://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3445507#M148607Martin_Weiss2022-05-30T13:29:52ZRe: Insert the numbers of a table in the last row of a different table (no VB)
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3445769#M148618
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MRAfshar3000_0-1653920929905.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/376149iB7B12015295CC177/image-size/medium?v=v2&px=400" role="button" title="MRAfshar3000_0-1653920929905.png" alt="MRAfshar3000_0-1653920929905.png" /></span></P><P>I tried to show my meaning in the photo</P><P>substations are not accurate , so I want to use the functions for entering numbers</P><P><LI-USER uid="48469"></LI-USER> </P>Mon, 30 May 2022 14:35:43 GMThttps://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3445769#M148618MRAfshar30002022-05-30T14:35:43ZRe: Insert the numbers of a table in the last row of a different table (no VB)
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3446033#M148630
<P>Hi <LI-USER uid="1376380"></LI-USER> </P><P> </P><P>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.</P><P> </P><P>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.</P><P> </P><P>I tried to rebuild a small example, I have also attached the example file:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Martin_Weiss_0-1653924947172.png" style="width: 674px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/376155i2E23245088630E39/image-dimensions/674x342?v=v2" width="674" height="342" role="button" title="Martin_Weiss_0-1653924947172.png" alt="Martin_Weiss_0-1653924947172.png" /></span></P><P>So in the above example, the formula in A14 would be:</P><P>=IFERROR(FILTER(A2:A8;C2:C8=A12);0)</P><P>The surrounding IFERROR just avoids that you get #KALK-errors if an account name is not found.</P><P> </P><P>Just note, that depending on your regional local settings you might need to replace ; with ,</P><P>So </P><P>=IFERROR(FILTER(A2:A8,C2:C8=A12),0)</P><P> </P><P>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.</P>Mon, 30 May 2022 15:41:11 GMThttps://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3446033#M148630Martin_Weiss2022-05-30T15:41:11ZRe: Insert the numbers of a table in the last row of a different table (no VB)
https://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3446039#M148632
I really thank you<BR />You helped me a lot<BR />Fortunately, my version is Minecraft 365<BR />I think you are also an accountant, so if it is possible to say some terms, for example, the same main table, we say newspaper book (my country)<BR />In privateMon, 30 May 2022 15:59:26 GMThttps://techcommunity.microsoft.com/t5/excel/insert-the-numbers-of-a-table-in-the-last-row-of-a-different/m-p/3446039#M148632MRAfshar30002022-05-30T15:59:26Z