Forum Discussion

zactaylor1's avatar
zactaylor1
Copper Contributor
Sep 23, 2025

Two lists of transactions. Want to create one large 'combined' one.

I have a workbook which I use for tracking transactions across two bank accounts.   Each account has a separate 'ledger' sheet which lists all the incomings and outgoings.     I want to create a ...
excel
Formulas and Functions
Macros and VBA
office 365
Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 23, 2025

Try the following formula-

=LET(_acc1,IFNA(HSTACK(IFNA(HSTACK(FILTER('Account 1'!A3:H50000,'Account 1'!A3:A50000<>""),""),""),"Account 1"),"Account 1"),
_acc2,IFNA(HSTACK(IFNA(HSTACK(FILTER('Account 2'!A4:G50000,'Account 2'!A4:A50000<>""),"",FILTER('Account 2'!H4:H50000,'Account 2'!A4:A50000<>"")),""),"Account 2"),"Account 2"),
comb,SORT(VSTACK(_acc1,_acc2)),CHOOSECOLS(comb,1,2,10,3,4,5,6,7,8,9))

 

Resources