i am sort of new at this and dealing with functions. i have a question about
indexing. once i have randomly generated a name or number from a list i
previously set up (and i got the random name by
using=index(a73:a173,rand()*99+1) how do i now generate another name but
making sure that the two names do not come up twice. is there an easy formula
for this?
i use it for numbers also, i guess there's no difference. in other words i
dont wont the names/numbers to come up twice when generating.
thanks.