Excel – Remove Everything But Duplicate Rows

In Excel, we all know that, there will be a moment in which we need the opposite the people usually need on usual Excel worksheets: this is the case of searching and filtering, from a dataset, only duplicates values, removing the unique ones. Read More …

Excel – Allow Certain Users to Edit Cells Range

Excel offers you an ability to assign user-level permissions to different areas on a protected spreadsheet. You can specify which users (usually local or Active Directory ones) can edit a particular range while the spreadsheet is protected. Read More …