Blog Stats
- 2,324,643 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?
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- Filter a list of items from a long long list
- Open an embedded Excel file during a slide show in PowerPoint?
- Insert a text string into a specific position of another text string in #Excel
- Dropdown calendar in Excel
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: December 2017
Season’s Greetings 2017
Ho…Ho…Ho… Merry Christmas! Wish you and your beloved ones a Merry Christmas and a Happy New Year of 2018! The above is made of #Excel of course… You may download a copy Seasons Greetings 2017 if you like it. š
#,##0, k or #,##0.0, k ? Why not both?
Conditional Custom Formatting in #Excel Got the following question: This gives me Ā£28.8 K (if 28800 is input) and Ā£28.0 K if 28000 is input. I was rather hoping that if there was no decimal after the thousand, ie Ā£28 … 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
Learn Excel Dashboard skills before end of 2017
Can’t believe it is already December.Ā Is learning Excel Dashboard one of your 2017 new year resolutions, that has not yet accomplished? If so, here’s a good news for you: Mynda Treacy’s popularĀ FREE Excel Dashboard Webinars are opened for the … Continue reading