jemal | jemal gem – Ruby interface to jemalloc | Data Labeling library

i try to get a random combination of different sentences. So i have five different types of sentences. Each type has between 5-8 example sentences. What i try to achieve ist that i always get one random sentence of each type. I've already tried a few things, but i don't get it really randomly. With the code i have there are only a few combinations that where shown again and again. Sometimes there appears "undefined" instead of certain sentences. Can someone help me, to get the it running really randomly and without the "undefined" thing.

Thanks a lot!

here's what i have already:

Currently, I want to automate some annoying work in excel and need some help.

I have a huge report which has 200k+ rows and about 500 columns and my task is to find out which cells of a column are never used. This was fairly easy and I managed it to create a script that works for that so far. But now I want to distinguish between row types and return for each row type whether there are columns that are never used. My problem is that I do not know how to iterate through the contents of a cell, so that if the row type changes my script will count the empty columns for the next row type.

I hope you get the idea and can help me. You do not have to give me the full code but maybe an idea of how I can get to the solution :)

This is the vba code I currently have and that gives me the correct solution but without distinguishing between the rowtypes