Enter the below into cell B2 and extend down. A2 is the lookup value, use dollar sign $ to lock to values on sheet 2, reference column 2 on sheet 2 and enter 0 for text. Sheet 1 Sheet 2
Author: contrib
Office 365 Add User to Teams in Bulk in Powershell
Create a CSV file with the following columns. User Powershell to import CSV file using Teams module.
YouTube Downloader
https://github.com/yt-dlp/yt-dlp
Semantic Versioning, Tilde and Carat, Composer and NPM
Tilde ~1.2.3 will update to the latest Patch version, so anything less than 1.3.0 Carat ^1.2.3 will update to the latest Minor and Patch versions, so anything less than 2.0.0
Search Column In Excel For Values That Do Not Exist
Enter the below into cell B2 and extend down to B5 to display values in column A that do not exist in column C To use whole column C instead, remove header and enter the below
Delegate Permissions to Reset User Account Passwords in Active Directory
To check the permissions after delegation
Bypass UAC Using Task Scheduler for a Program
Open Task Scheduler and Create a New Task under Actions In General tab. Give the task a name.Tick ‘Run with highest privileges’. In Actions tab Click New, set action to ‘Start a Program’Browse to the program location in program/script. In Settings tab Tick ‘Allow task to be run on demand’. Create a shortcut with the […]