Hi,
I have the below formula in excel, and am facing problem to skip empty cells while random selection
=INDEX(H3:H25,RANDBETWEEN(1,COUNTA(H3:H25)))
Any body can help?
Thanks
Hi,
I have the below formula in excel, and am facing problem to skip empty cells while random selection
=INDEX(H3:H25,RANDBETWEEN(1,COUNTA(H3:H25)))
Any body can help?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks