-
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
Categories
-
Power BI 1
Top Excel articles
-
-
-
Creating a SPLIT function in Excel using lambdasCreating a SPLIT function in Excel using lambdas- Dermot
- Updated:
-
You Are Invited to Post Your Articles at MrExcelWant to document some cool Excel technique? Write it up here.- MrExcel
- Updated:
-
Loan Amortisation ScheduleUsing Excel's new dynamic array forumlas, we can easily generate a loan amortisation schedule.- DRSteele
- Updated:
Latest reviews
-
MoreQuery for MacThis is most useful article to me as a Mac Excel user. Detailed explanation is invaluable...
- nk24
This article shows how to list parents and children that form the structure of Web pages.
How to generate the last 52 Monday dates in a column
The four steps to make sure someone on the Excel team reads your feedback
Using Excel's new dynamic array forumlas, we can easily generate all permutations of three variables
Using a new statsitic, we can rank performance by using cascading tiebreakers
How to detect cycles in all variants fo Excel
Using Excel's new dynamic array formulas, we can easily generate a calendar based on a date
Using Excel's new dynamic array formulas, we can easily Split text cell into columns of words.
Using Excel's new Data Type for Stocks, we can easily generate a list of stock market data
Using Excel's UNICHAR function, we can create a grid of nearly all the characters in Excel
Column title formula for cells extracted from the field selector
Copying Lambdas between workbooks and keeping them updated
Using Excel's stock data types, we can calculate the cross currency rates from a few currencies.
Getting the right security with Stock Data Types is frustrating
get STOCKHISTORY to report ALL the data between two dates
Use Visible Rows for dynamic row numbers, conditional formatting every other row.
18 point Waterfall Chart with Dynamic Ranges and Automatic Chart Update
Implements a shortest path algorithm for a 3D problem.
This code lists all page addresses on a given worksheet.
