Filtering and getting random spreadsheet rows

I was thinking of donig something like this in excel: http://img170.exs.cx/img170/1358/excel6vz.png

Does anybody know how I would be able to randomly select rows that have an index value within a range I can change? Sorry if it's kind of confusing; take a look at the pic if you don't get what I mean.

I was thinking about doing it in excel, but with the amount of data it'll be going through, that may not be the best option. (~300 rows, 5 columns)

So, if not excel, what would be the easiest way to store data and make a program like this?

VBA

>>2
ZOMG VIRUS

Seriously though, have you checked Excel's random function? You can surely use two other cells as indexes to calculate * and + factors for it.

yeah I don't really know excel and he asked for the easiest solution and I gave him the easiest I knew

LI        SP    LISPLISP   PLISPL
SP        LI   IS          IS   SP
LI        SP   PL          PL   LI
SP        LI    SPLISPL    ISPLIS
LI        SP          SP   PL
SP        LI          LI   IS
LISPLISP  SP   PLISPLIS    PL

LI        SP    LISPLISP   PLISPL
SP        LI   IS          IS   SP
LI        SP   PL          PL   LI
SP        LI    SPLISPL    ISPLIS
LI        SP          SP   PL
SP        LI          LI   IS
LISPLISP  SP   PLISPLIS    PL

See-plus-plox

Module named pygtk Get!

11 Name: Anonymous 2011-02-18 13:40

<-- check 'em dubz

12 Name: Anonymous 2011-03-02 21:31

I AM THE MOST FUCKING NGGER MATURE

13 Name: Anonymous 2013-04-20 17:56

check em

---

Don't change these.

Name:		Email:
Entire Thread Thread List