Blog Stats
- 2,374,255 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Open an embedded Excel file during a slide show in PowerPoint?
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: November 2015
Excel Humor #1 – Home
I am now having fun somewhere in Tasmania; enjoying my vacation 🙂 So let’s have fun this week and the next.
Bug with copy and paste in Excel Table
Do check what you do! On top of human errors, there may be bug hidden. Continue reading
Nested IF vs. VLOOKUP – Which one to use?
A well-drawn flowchart or a well-organized table helps you write a successful formula effectively Continue reading
IF, it is too complicated…
Writing an IF function is quite straight forward, if there is only one logical test involved. For example, we want to comment on a shop’s performance by looking at its actual sales. If Actual hits Budget, then Good job, else … Continue reading