All articles with 'dynamic array formulas' Tag

Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number of years.

How about a fun Excel challenge? I have data in below format in the table named trips I want to know which employees visited both USA & UK? How would you solve this problem? Post your solutions in the comments. Need sample data & my solution? Click here to download the file. Want more challenges […]