-
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:
-
Macro to create searchable data validation+comboboxSpeed up searching in long list data validation & easy to set various specific behaviors- Akuini
- Updated:
Trending resources
-
Excel article icon
-
Excel article icon
-
Excel article icon
-
Excel article icon
-
Excel article icon
Resource statistics
- Categories
- 5
- Excel Articles
- 74
- Downloads
- 12,791
- Disk usage
- 748.7 KB
This article calculates the path of a ricocheting object inside a closed 2D area.
Office 365, Reduce, Lambda
This article provides a way to add two colours together
This article provides code to generate a kind of chart that Excel does not offer
We can get rid of things like punctuation from a textstring in a cell.
This article shows how to list parents and children that form the structure of Web pages.
This article shows six different ways to draw a flag.
A simple method of taking a PNG or full-page PDF snapshot of a webpage
Getting the right security with Stock Data Types is frustrating
VBA: Enhance and speed up random numbers and sorting, using spill functions
Speed up searching in long list data validation & easy to set various specific behaviors
VBA Macro to create Word & Phrase Frequency
Creating a SPLIT function in Excel using lambdas
Using Excel's stock data types, we can calculate the cross currency rates from a few currencies.
Copying Lambdas between workbooks and keeping them updated
How to translate text to multiple languages.
Column title formula for cells extracted from the field selector
A new Rolling Calendar Control as a Date & Time Picker
