Dear Friends,

When I created a named range with offset function for dynamic list with the following formula using OFFSET function, it was not selecting as I required:

=OFFSET(Master!$A$3,0,0,COUNTA(Master!$A:$A),-1)
The data starts from row 3 as follows:

	
Code	Company Name
AA	AA Company
BB	BB Company
I would like to make dynamic name list for Code column. When I applied the above OFFSET formula in named range, the list consist of both "Code" & "Empty" also.

Similarly, I would like to create more dynamic ranges in the same sheet for various columns.

Kindly suggest how to make a dynamic range in which I can have only the data available in the related column.

yours,
acsishere.