Hi jfinnegan0. Welcome to the forum.
With this quote in mind I suggest converting the data to a Table. If you are not familiar with tables they resize automatically to fit the data.
(which can change if more data is added
The formulas use table syntax (referencing field names rather than ranges).
Array enter this formula. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Bookmarks