The attached Excel file is a simple example for my project with 10K rows. "WEST ex CA" and "CENTRAL ex AR" in the drop down box is not working. How to modify the formulas in G4-G9 to make them working? Help needed! sample.xls
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code)
David miller (dlmille)
Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.