https://developerpublish.com/how-to-apply-formula-to-entire-column-without-using-autofill-in-microsoft-excel-2016/
How to apply formula to entire column without using AutoFill in Microsoft Excel 2016?