Is there a way to search every cell containing [pattern] and clear it if the pattern exists? Searching on this topic has been fruitless for me ... many ways to delete the entire row or filter out the row but I just want to clear contents of a cell if it contains pattern "xyx" anywhere in it.
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…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…