Why is the range extended to row 43 even though the unit numbers end in row 42?
The range is extended to row 43 to allow for scalability and ensure that the formula automatically adjusts if more units are added to the dataset in the future.