I have 1000 numbers. I have to form 100 groups each group containing 30 nos from those 1000 numbers. How should I do it?
I have 1000 numbers. I have to form 100 groups each group containing 30 nos from those 1000 numbers. How should I do it?
Last edited by arajkum; 10-12-2013 at 01:58 PM.
Hi and welcome to the forum
To fit in with Fotis comment, maybe something like...
Group numbers into groups
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have changed the Title. can you please help me out now?
=RandomSelection($B$2:$B$1001)
This worked for my friend but it dosen't work for me
RandomSelection is not a regular 2003 function, nor is is in 2007. It may be a UDF (User Defined Function - VBA) that your friend made, or had made
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks