If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel articles and downloadable files provided in the articles have not been reviewed by MrExcel Publishing. Please apply the provided methods / codes and open the files at your own risk. If you have any questions regarding an article, please use the Article Discussion section.

General Excel

C
How to Trick Vlookup to look in any direction
Vlookup criteria
- CA_Punit
- Updated: Jul 29, 2020
Creating a SPLIT function in Excel using lambdas
Creating a SPLIT function in Excel using lambdas
- Dermot
- Updated: Oct 31, 2021
Suppressing zeros
How to display a blank cell instead of a zero as a result of a formula
- Eric W
- Updated: Jul 28, 2020
Loan Amortisation Schedule
Using Excel's new dynamic array forumlas, we can easily generate a loan amortisation schedule.
- DRSteele
- Updated: Dec 2, 2019
You Are Invited to Post Your Articles at MrExcel
Want to document some cool Excel technique? Write it up here.
- MrExcel
- Updated: Dec 2, 2019

Filters

Using Excel's new dynamic array forumlas, we can easily generate a loan amortisation schedule.

5.00 star(s) 1 ratings

Using Excel's new dynamic array forumlas, we can easily generate all permutations of three variables

0.00 star(s) 0 ratings

Want to document some cool Excel technique? Write it up here.

5.00 star(s) 1 ratings

The four steps to make sure someone on the Excel team reads your feedback

0.00 star(s) 0 ratings

How to generate the last 52 Monday dates in a column

0.00 star(s) 0 ratings