I have a page (or two..) with 300 cells of words, no numbers.
I need to shuffle the order of the entire collection so that I can print out a different order every time; let's say 3 columns a page until I have inserted all the words.
I did try numerous searches but all I come up is the RAND function thingy; I don't want number appearing on my printouts, I need the words with enough space after to enter comments.
Either Word or Excel or anything else would work.
Thanks.
Use the RAND thingy and don't include the RAND thingy column in the print range.
Entia non sunt multiplicanda sine necessitate
That's it then, no other way?
There are a hundred ways to do it, but you haven't provided any information about why the simplest approach is not well suited to your problem, or described your workbook layout in sufficient detail to suggest an alternative.
Posting a workbook with some additional explanation might invite other ideas.
Last edited by shg; 08-19-2012 at 04:00 PM.
shg,
I have worked it out in the included manner, it's a list of airport identifiers so that the user can randomize, printout and memorize them; there's enough space next to each identifier to enter decode the 4 letter ICAO code or encode the city, depending on what is presented.
The two columns here are individually randomized but I was hoping to have both columns inter-mixed and randomized as a whole.
This is as good as it can get is what I gather, aside from the fact that I can't interchange the two columns, the only other issue is that when I print the list out, I have to make sure the page breaks are good.
ICAOfull.xls
Last edited by MrBurns; 08-19-2012 at 10:41 PM.
Just some thoughts ..
Think what you are currently using is IMO, a simple, effective way to randomize
As for this line ..
> .. I was hoping to have both columns inter-mixed and randomized as a whole
You could stack the 2 col source lists up into a single col range, then randomize this range into another col (in the way you're doing it right now), then split it into 2 cols as the final output
To split a single col into 2 (zig-zag style*),
you could use something like this
Assuming your single col data runs in J1 down
Put in K1: =OFFSET($J$1,COLUMNS($A:A)-1+ROWS($1:1)*2-2,)
Copy to L1, fill down as far as required to exhaust the extracts
*Eg
Source data
1
2
3
4
etc
Into Zig-zag output
1 - 2
3 - 4
etc
Perhaps as attached.
Not entirely sure how you did that but it looks great! Thanks! If you could give an explanation in case I want to make font size changes, it would be appreciated..Originally Posted by shg
Max, Thanks for your input as well, I tried to get it to function last night but couldn't, probably some parameter I got wrong or was too tired...
Last edited by MrBurns; 08-20-2012 at 04:57 PM.
> .. Max, Thanks for your input as well, I tried to get it to function last night but couldn't, probably some parameter I got wrong or was too tired
No worries. If you're happy with what shg has provided you, then that's best. Should you wish to pursue my inputs (it should work as well for you as it did for me) please continue to ask, let me know how you tried it out.
That's pretty cryptic, MB, which is not in the nature of the pilots I know, including YT.If you could give an explanation in case I want to make font size changes, it would be appreciated..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks