Auto adjust cells to fit data
cntl + a then while holding alt type hoi
Average and ignore zero cells:
=AVERAGEIF(B7:M7,"<>0")
I haven't used this yet but plan to on the next Win 11 implementation. The .bat file to run the .ps1 Paste the following into a notepad ...