How to pick a random cell with criteria

[Z7-852]

I need help to pick a random cell with criteria in open office math.

I have large spread sheet with multiple cantidates and I need to pick one out of them at random.
On first row I have different criteria (A column is for name and rest B to W are different attributes).
After this I have a lot of rows of canditates from wicth i need to pick one out at random. This would be easy enough but I need that the canditate must fulfill certain (chainging) attributes.
At the moment I have only used standart filter to found out possible canditates and used scroll to pick one out at random. But this isn't accually random pick.

So I need to know how to do this propebly. So I have cells where I write what criteria should the pick have (B to W) if any. Then I need a cell that picks me one name (A) at random from all the canditates at random.

Meaning that if i first need a one that has
B=1 C=0 and F=1 it will pick me one that fullfills these criteria. But if my criteria chances to B=1 F=0 W=0 I can pick a new one without chaincing anything execpt the search criteria (so no new function writing).

All the criteria are 0,1 type of information.

[Moved to Calc – Robert Tucker, Moderator]

[Villeroy]

In a database it would be as trivial as:

[ken johnson]

Perhaps something like attached doc (Random Candidate wrt 22 Criteria.ods)...
http://www.mediafire.com/view/?bvpmbt1yd7golzx
Start by selecting B2:W2 then pressing Backspace key to remove old selecton criteria, then use the data validity selection list (0;1) to enter new selection crieria.
Selection criteria in B2:W2 left blank result in those criteria being ignored.
Random name from candidates satisfying the entered selection criteria appears in X2.
Helper columns Y, Z and AA can be hidden.
If more than 100 names fill Y3:AA3 formulae down.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).