This fast tip demonstrates how to use conditional formatting in Excel to highlight duplicate values within a column of data.
In another Fast Tip Friday, I demonstrated how to highlight duplicate rows using Excel.
This fast tip demonstrates how to use the SUBSTITUTE formula in Excel. NOTE: While I realize that we could simply replace JONES_ with JONES- in this example, I wanted to keep things simple and leave it up to your imagination to see how useful this formula could be one day in your future. 🙂 Download…
This fast tip demonstrates how to perform a search and replace across multiple PDF files using Adobe Acrobat. This feature is available in both Acrobat XI and DC.
This fast tip demonstrates how to use the VLOOKUP function in Excel to compare two lists of bates numbers and then a couple of ways to visually present the results. In a previous fast tip, I demonstrated an alternative way to use Excel to compare two lists. Download Sample Files
This fast tip will demonstrate how to use DOS commands to create a file listing. In another Fast Tip Friday, I demonstrated how to get a list of all files in a folder using an Excel macro. Download Sample Files
This fast tip demonstrates how to delete a persistent drive mapping using a DOS command.
This fast tip demonstrates how to use an Adobe Acrobat action to perform searches across multiple PDF files, highlight all of the terms and extract the pages that have hits highlighted. The highlight colors available to use in the javascript are listed below: color.transparent color.black color.white color.dkGray color.gray color.ltGray color.red color.green color.blue color.cyan color.magenta color.yellow…
One Comment