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

Plex Setup

File Structure and Naming C:\TV Shows\ └── Bull\     ├── Bull - S01E01.mp4     └── Bull - S01E02.mp4