Select Random Records With Multiple Criteria

**AlexRoberts** · 10-03-2011, 08:57 AM

Please can somebody can help me.

I am struggling to find examples of a formula that shows how to generate a random selection of records using multiple criteria, there are many for a single criteria using the RND Function.

I want to randomly select 2 records of each Type (pavement, potholes, etc) for each of the Areas (Essex, Kent, etc).

I have enclosed an example spreadsheet.

Thank you.

**watersev** · 10-03-2011, 10:07 AM

hi, AlexRoberts, sort of that, check attachment, run code "test"

**AlexRoberts** · 10-04-2011, 02:43 AM

Watersev,

Sort of is not the right word, perfect is.

Thank you.

**AlexRoberts** · 10-04-2011, 04:18 AM

Watersev,

Sorry, I have come across a couple of issues,

1. the macro does not create a record for the last Area / Type combination,
2. the macro hangs if the number of rows increases.

Do you have any ideas what the problems may be.

Thank you.