I have a list which is a combination of two cells for records. For example something like A1&B2. Sometimes this is not filled however. The formula below sees that it has A1&B2 in the field so regardless it thinks it's fields even though the field would be considered "".
=OFFSET(CCS_Error_Tracker!$A$5,0,0,COUNTA(CCS_Error_Tracker!$A:$A),1)
Is there any way this could be configured truly to look for blank spaces?
I think this is what you are looking for:
=$A$5:INDEX($A$5:$A$1048576,ROWS($A$5:$A$1048576)-COUNTBLANK($A$5:$A$1048576))