k
1
2
3

=COUNT(A:A)

=RANDBETWEEN(2,$B$2)

{ DATABASE d "c:\xl\rnd.xlsx" s "SELECT mycolumn FROM [Sheet1$] WHERE k = { DATABASE d "c:\xl\rnd.xlsx" s "SELECT r FROM [Sheet1$]  WHERE k = 2" }" }