"Do Until Matches Criteria"-Loop Thru Randomised Range, With Counter

Hi.
I need to create a macro that will firstly create a random (=RAND ()) range of numbers (e.g. between 0-20), then repeatedly randomise these numbers (F9) until, let's say, 5 of them match 5 other numbers (within the same range) specified in a separate row (i.e. "do until" loop, until criteria are met), while at the same time counting the number of times it repeats the loop until it matches the criteria. Upon matching the criteria, it must show the resultant number of loops (F9's) in a separate cell. It must then repeat the procedure for subsequent rows until it reaches an empty row of cells.
Any ideas greatly appreciated.

suppose range is only column range A1 to A25
quote
5 of them match 5 other numbers (within the same range)
unquote
explain this with example so that I can attept.

for filling the above range with random nos. this is the macro

Please Login or Register  to view this content.