Tag Archive

Tag Archives for " intermediate-advanced "

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


I receive a lot of requests for help with setting up files/charts (most often in Excel).  Occasionally I think people try to challenge me on purpose by setting certain restrictions. In one case, I was given a table of weekly numbers and asked to visually highlight if one week was higher or lower than the […]

Continue reading

Get every new post delivered to your Inbox

Join other followers: