excel: select 50% randomly of cells

[ezechiel]

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?

[Guido Geurs]

Dear,


I hope this will solve your problems (see attachment)

br,

[ezechiel]

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!!