By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,650 Members | 1,785 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,650 IT Pros & Developers. It's quick & easy.

excel: select 50% randomly of cells

P: 53
I've been looking for this on the forum, but didn't find anything in relation with excel.

So, I have cells with text, from A3 -> A159
And I need to select 50% (or 25% or 12.5%) of these cells randomly.
I also need a function to select 10 cells randomly.

Anyone has an idea how I could do this?
Dec 8 '09 #1
Share this Question
Share on Google+
2 Replies


Guido Geurs
Expert 100+
P: 767
Dear,


I hope this will solve your problems (see attachment)

br,
Attached Files
File Type: zip x% randum select_v7.zip (24.4 KB, 68 views)
Dec 16 '09 #2

P: 53
Hi,

just tested this and this is: EXCELLENT ^^
Thansk a lot. I'll dive into the code to adapt it to my needs.
But thanks again, great job!!
Dec 22 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.