Create a dynamic range name.
Insert>Name>Define... with a name of rngPop, and a Refersto value of
=OFFSET($A$1,,,COUNTA($A:$A),1)
and then use this in the function call
Sample(rngPop, no, True, False)
Create a dynamic range name.
Insert>Name>Define... with a name of rngPop, and a Refersto value of
=OFFSET($A$1,,,COUNTA($A:$A),1)
and then use this in the function call
Sample(rngPop, no, True, False)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote