Hello All!!
I am using the below formula to select a random cell from the list A1 to A26. This range has few blank cells, hence I want to ignore them and only return cells with value whenever excel calculates.
Anyhelp will please.
Formula:
Please Login or Register to view this content.
Try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Here is a User Defined Function that will do what you want also.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks a ton to all.
They worked for me.
hi. how to INdex to skip blank use random and if
123.png
Hi,
I have the below formula in excel, and am facing problem to skip empty cells while random selection
Range("C9").Formula = "=INDEX('Sorted Names'!$H$3:$H$5,RANDBETWEEN(1,COUNTA('Sorted Names'!$H$3:$H$5)))"
Any body can help?
Thanks
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Thread closed.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks