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")

Compare Hash With Powershell

Insert actual values over the ( ) locations. Remove the ( ) Place it all in a hash.ps1 file and run.  $h='(put hash here)';$f="...