Blog Stats
- 2,433,099 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?
- 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
- When unhide row doesn't work...
- Dropdown calendar in Excel
- Be cautious when using XLOOKUP
- Filter a list of items from a long long list
- Insert a text string into a specific position of another text string in #Excel
- Calculating CAGR with Goal Seek in #Excel
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: July 2015
SUM Time in the end of text strings
Did you encounter a task like this? I did. Actually it is not as difficult as you may expect. It could be done in just a minute IF the data is not too bad, like the one shown above. I … Continue reading
Posted in Excel Tips, Formula
Tagged Array formula, Find and Replace, RIGHT, Sample File, SUBSTITUTE, SUMPRODUCT, Time, wildcard
6 Comments
Ctrl+A can be more convenient than you think of…
If you think Ctrl+A does merely Select All, then you are likely not using it frequently. Let’s me take you through how to boost your efficiency working with Excel with Ctrl+A under different situations.
=SUM(‘???’!C3) Is it a valid formula?? No. It is magical indeed!
This is about using wildcards in referencing cells on other worksheets. If you know the basic rule about naming a worksheet, you should know that we cannot use ? or * in any part of a worksheet’s name. So there … Continue reading
Excel 2016 is coming! Is your company ready for this?
If you Google “Excel 2016 preview”, you will find many previews and comments for Excel 2016 on the Internet. I have not tried Excel 2016. Indeed, I have not yet tried Excel 2013 either, although I keep an eye on … Continue reading
Posted in General
2 Comments