- Excel VLOOKUP Between Sheets to Match Column with Reference
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
- 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