Rvn1304’s gists

ncalm / excel-lambda-RANK.DENSE.txt

Last active December 14, 2024 19:50

This Excel lambda function provides a ranking mechanism similar to SQL's DENSE_RANK, but follows the pattern of RANK.AVG and RANK.EQ

	/*
	RANK.DENSE

	Ranks a one-dimensional array using the provided sort order. If adjacent items have the same value, they are all given the rank of the first of them.
	Ranks following equally ranked groups increment by one from the most recent rank. This is as opposed to RANK.EQ where following ranks are given the rank
	they would have received if the same-ranked items were given different ranks. As such, this function behaves similarly to SQL's DENSE_RANK

	Inputs:
	Number - A number or array of numbers to find the rank for from the ranks given by Ref sorted by Order
	Ref - A list of numbers to be ranked, from which the rank of Number will be found

thdtt / activate.cmd

Last active December 2, 2025 10:53

Office 365 Activator; dont forget to turn off windows defender real time protection

@echo off

title Activate Office 365 ProPlus for FREE - MSGuides.com&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products: Office 365 ProPlus (x86-x64)&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b ..\root\Licenses16\proplusvl_kms*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&(for /f %%x in ('dir /b ..\root\Licenses16\proplusvl_mak*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&echo.&echo ============================================================================&echo Activating your Office...&cscript //nologo slmgr.vbs /ck

mndambuki / officeActivator.bat

Created June 7, 2020 03:41

Activate Microsoft Office 2019

	@echo off
	title Activate Microsoft Office 2019 !
	cls
	echo ============================================================================
	echo #Project: Activating Microsoft software products
	echo ============================================================================
	echo.
	echo #Supported products:
	echo - Microsoft Office Standard 2019
	echo - Microsoft Office Professional Plus 2019