- Home
- data validation 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 […]
Continue readingFormula 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 […]
Continue readingData 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 […]
Continue readingData 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 […]
Continue readingData 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 […]
Continue readingData 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 […]
Continue reading