[Affiliate]
Blog Stats
- 3,029,328 hits
-
Join 3,904 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Simple Basket Analysis - Formula approach with #Excel 365
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Insert a text string into a specific position of another text string in #Excel
- Rename column names in a dynamic way with #Excel #PowerQuery
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Perform VLOOKUP with 2 lookup values
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Excel Table
[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
SUM the last X non-blank values in a column in #Excel
Got this question from my brother. He is tracking scores for game he plays with friends. The game can be played with up to four players. He wants a formula to calculate the last 10 scores of a player. He … Continue reading
Hard-coded range expands automatically with #Excel Table
The INDIRECT trick of using Structured Reference in Conditional Formatting Is it a feature or a bug? This is an extension of the previous post, in which we discussed the use of INDIRECT trick to deal with Excel Table in Conditional … Continue reading
The INDIRECT trick of using Structured Reference in Conditional Formatting
When setting up conditions for Conditional Formatting in Excel, have you ever tried to set a formula that refers to a Excel Table, but failed?
First of all, why we want to refer to Excel Table in Conditional Formatting? There is one simple answer: To accept new data automatically.
To use Structure Reference in Conditional Formatting, we need an INDIRECT approach which is discussed here. Continue reading
Get a list of pending tasks and sort by due dates
A common task – Get and sort a list of tasks that are not yet due according to due dates Got the following question: Suppose on column A I have entries and on column B i have due dates for … Continue reading