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

NovaBenchmark

 On my old Predator 17                                 My Ryzen 5 at the office