Monthly Archives: December 2015

VLOOKUP the Nth matched item, with helper column

Posted on December 24, 2015 by

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 →

Rate this:

Posted in Formula | Tagged , | Leave a comment

How to limit time interval input in a single cell?

Posted on December 19, 2015 by

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 →

Rate this:

Posted in Excel Tips, Formula | Tagged , | 4 Comments

A simple trick to go to a specific picture quickly

Posted on December 12, 2015 by

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 →

Rate this:

Posted in Excel Tips | Tagged | 5 Comments