Blog Stats
- 2,325,650 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"
- Combine files of (slightly) different layouts in a folder with Power Query in #Excel
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Filter a list of items from a long long list
- Sequential number for visible rows only
- Dropdown calendar in Excel
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: December 2015
VLOOKUP the Nth matched item, with helper column
This should be the last post in 2015. So it’s better to answer unanswered question in the year. 🙂 Question: “VLOOKUP will return the first matched value found, in case there are multiple matched records what formula should we use?” This … Continue reading
How to limit time interval input in a single cell?
Got the following question from a reader: Under data validation, is it possible for me to restrict the time duration (in a cell) to be 30mins or less? Example: 9.00 – 9.30 (accepted) 10.15 – 10.50 (rejected) Obviously, the answer … Continue reading
A simple trick to go to a specific picture quickly
Here’s the situation: You have many pictures on a spreadsheet, how can you go to a specific picture quickly? Selection and Visibility Pane is on the top of my mind…… but as you see from the above screenshot, you won’t succeed … Continue reading