[Affiliate]
Blog Stats
- 3,191,048 hits
-
Join 3,265 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to sort bar chart in descending order?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Highlight weekends and holidays using Conditional Formatting in #Excel
- Show number in thousand (k) or in million (M) by using custom format
- Open an embedded Excel file during a slide show in PowerPoint?
- Append tables with inconsistent column names with #Excel #PowerQuery
- How to replace value with a value from another column in Power Query
- Calculating CAGR with Goal Seek in #Excel
- The INDIRECT trick of using Structured Reference in Conditional Formatting
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Dynamic Arrays
Split text with delimiter(s) into columns or rows and even table with TEXTSPLIT in #Excel365
It’s a common task to split text into columns in Excel. We can do that with “Text to Columns” under Data tab. That’s very handy, however it returns only static result (good for one off task) and could not split … Continue reading
[Video] How to create a dependent dropdown list in #Excel
This is the follow up post from my previous post – How to create a dependent dropdown list in #Excel. As mentioned, it could be easier to illustrate the concept using a video, especially for the use of Dynamic Arrays. Here … Continue reading
Posted in Excel in Action
Tagged Dependent Dropdown, Dynamic Arrays, Excel Table, Filter, INDIRECT, UNIQUE
Leave a comment
How to create a dependent dropdown list in #Excel
…with and without Dynamic Arrays (which is available to Microsoft 365 users only) Got a question from a friend recently: Is it possible to show a different set of questions in a dropdown list depending on the answer input from … Continue reading
Posted in Excel in Action
Tagged Data Validation, Dependent Dropdown, Dynamic Arrays, INDIRECT
2 Comments
What’s new in Excel 365?
Are you using Excel 365 but not sure what’s new? Have you heard about all the amazing new functions/features like Dynamic Arrays in Excel 365 but not sure what they are? Or you have no idea at all how Excel … Continue reading
Determine leap year with #Excel
Today is a special day. Today is February 29th, which happens only once every four years. And today is Saturday, when I usually post a new blog. So let’s talk about how to determine if a year is leap year using … Continue reading
Free Template: Party Expense Calculator
Christmas has just passed while New Year is just around the corner. Party must go on! As a token of appreciation for you visiting my blog, I am going to present you a free gift – Party Expense Calculator, in … Continue reading
The power of Dynamic Arrays in #Excel 365
… in creating dynamic drop-down with conditions Making a dynamic drop-down list is not difficult. It may require multiple steps, helper formula and/or helper tables though. And the number of helper tables depends on the complexity of the requirement. I … Continue reading
Posted in Excel in Action, Excel Tips
Tagged Data Validation, Dynamic Arrays, Dynamic Dropdown, SORTBY, SUMIF
Leave a comment
Dynamic Shrinking Dropdown with Dynamic Arrays in #Excel 365
The recent HOT topics about Excel should be the new Dynamic Arrays! After watching all the amazing demonstrations about the new Dynamic Arrays, I’ve decided to sign up to the Office Insider (Fast) programme (for Office 365 subscriber only). … Continue reading
Posted in Excel Tips
Tagged Data Validation, Dynamic Arrays, Dynamic Dropdown, Excel 365, MATCH
Leave a comment
wmfexcel 