Tag Archive

Tag Archives for " Excel "

Searchable Drop-Down List In Excel

This post will tell you how to create a searchable drop-down list in Excel. After my earlier series of posts on Data Validation and drop-down lists, I received requests for further help and how to create a searchable drop-down list in Excel. The image above shows a searchable drop-down list. The letters PP are entered […]

Continue reading

OEE Solution – Querying Various Sheets

In this post we will pull together formulas that we’ve seen in these posts Formula to get first, second and third highest values Formula to get last row number http://blog.thejaytray.com/excels-indirect-function/ Data Validation Lists COUNTIF Function Before continuing, if you are not familiar with the above posts or functions I would recommend reading them.  Although I […]

Continue reading
1 2 3 6
Follow

Get every new post delivered to your Inbox

Join other followers: