Forum Discussion
Help me in this formula
Hello Community Members, I’m a Student and I have to submit an excel project for which I need to prepare a workbook in which a client can enter his/her daily transactions. Sheet-1 named Transaction...
Unless this class is specifically calling for legacy-based Excel formulas, you'll want to use FILTER in the bank account sheets to pull from the Transactions sheet. The INDEX array you're trying was the work around used in Excel before the advent of dynamic arrays.