Tag Archive

Tag Archives for " drop down lists "

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 […]

Formula to get first second and third highest values

In this post I will show you how to look up the first, second, third and so on values.  This formula can also be used to create Pareto charts which I will also go through in the next post. In previous posts I touched on the idea of having a file that could quickly query […]

Data Validation List Based On Criteria

In earlier posts, we covered data validation list, from basic to more complex rules.  In this post, we will create a rule for a Data Validation List that will be dependent on another value. If you want to read back over earlier posts, you can click on the links below. Introduction to Data Validation Lists […]

Data Validation List To Automatically Update Source Range

The last 2 posts looked at some Data Validation options in Excel for either a short list or a set range of cells. This time we will use a formula in our Data Validation rule that will work out what range of cells to base the list on. Data Validation Rule To Update As List […]

Data Validation List Based On Range Of Cells

In the last post we created a short Data Validation List where we typed in the options for our drop-down list. This time we will create a Data Validation List based on a list in a range of cells. In this example we will create Data Validation Lists to column A and the options in […]

Data Validation List In Excel Introduction

In the next few posts we will look at Data Validation Lists in Excel.  You may have seen these and called them drop-down lists.  We will start with the most basic form of a small Data Validation List and then get more advanced. For this post, we will create a Data Validation List based on […]

Follow

Get every new post delivered to your Inbox

Join other followers: