I have a dynamic name range called Serialnums which references all the rows in column B in the EquipmentData Sheet. However the range is not including all cells as there are 17 rows below containing data in the same column not included in the range, and I can't figure out why. This is my formula:
=OFFSET(EquipmentData!$B$1,1,0,COUNTA(EquipmentData!$B:$B)-1,1)
I have also attached my worksheet.
Bookmarks