Thursday, October 13, 2022

Excel Hints

 Auto adjust cells to fit data

cntl + a then while holding alt type hoi


Average and ignore zero cells:
=AVERAGEIF(B7:M7,"<>0")

at
Labels:

Make Your Own Ninite Installer

Ha, Ok - not quite. You have to download the installers first. I could add curl, extract and delete requests but it's too much work for ...