Drop down cells and looking up related information Jun 20, 2012 Adrian How to base a drop down list on the outcome of another dropdown list Read Article
How to rank items that have the same rank?? Jun 20, 2012 Adrian How to address the issue where the rank of items needs to be the same but the Excel RANK function ignores all but one of the ranks Read Article
Green Marks inside Excel cells Jun 20, 2012 Adrian Explanation of what the little green notes inside Excel cells are and how to use them Read Article
Conditional Formatting across sheets Jun 20, 2012 Adrian How to perform a conditional format that needs to look at a different sheet. Read Article
AND and OR functions Jun 20, 2012 Adrian The question is a bit unclear but from what we see you should be using the AND and OR commands. See how to use them on https://www.auditexcel.co.za/AND_OR.html . Hope this helps, otherwise it is better to send a spreadsheet. Read Article
Pulling every 17th cell into a consecutive list Jun 20, 2012 Adrian How to pull every xth cell into a consecutive list using the OFFSET function Read Article