Could someone assist me with the correct syntax to perform the following:

I want to define a named ranged starting at cell B2 that expands down to the last entry based on column A. Column A has no empty cells and B does and the values are discontinuous.

In other words, create a dynamic range based on col B minus the first cell (B1) that includes as many remaining cells that are full in col A.

My attempts continue to add one extra cell at the very end of the range.

ie. OFFSET($B$2,0,0,COUNTA($A:$A),1)

Thx

Glad to help.