Last seen: Oct 31, 2025
In the example that I provided the rows of information are not in a structured table, they are just different colors. As for using different formul...
Here is the file that is an example of what I want to do
Discovered the solution and why the previous formula didn't work. The correct formula, that works is =SUMPRODUCT(--(YEAR(Withdraws[Date])=2023...
Since I posted this question, I actually found a solution that almost satisfies the question. This function works: =GET.CELL(63,INDIRECT("rc, FALSE...
Thanks for the offer Anders. After finally figuring out what the user wanted it turns out it wasn't really about amortization. It was more about ca...
Thanks for the quick response. I saw different versions of this when I did the Google search unfortunately this doesn't satisfy the requirement tha...
@Velouria Don't want to forget you in my appreciation, the SCAN is a lot easier to understand than MMULT as I still struggle with conceptualizing arr...
Once again, thank you, great tip for someone learning LET
Thank you both, the solution works perfectly. Now I have to understand what you did