.. I wanted to fill the column C fully satisfying the condition
and by changing the random values in the columns A & B ..

Perhaps one indirect way to achieve this
while preserving the randomization in cols A & B

Extending the earlier set-up, which is presumed
in Sheet1, within A1:C10 (say)

In Sheet1,
Put in D1: =IF(C1="","",C1+ROW()/10^10)
Copy D1 down to D10

Then, in a new Sheet2, we could
-------------
Put in A1:

=IF(ISERROR(SMALL(Sheet1!$D:$D,ROWS($A$1:A1))),
"",INDEX(Sheet1!A:A,MATCH(
SMALL(Sheet1!$D:$D,ROWS($A$1:A1)),Sheet1!$D:$D,0)) )

Copy A1 across to C1, fill down to C10
(cover the same range size as in Sheet1)

Sheet2 will return only the lines from Sheet1
satisfying all the conditions, neatly bunched at the top

Pressing F9 will recalc/regenerate afresh the results in Sheet2

The number of lines showing in Sheet2's cols A to C would vary with each
recalc (each press of F9). So you could recalc until you're happy with the
number of lines generated in Sheet2 (but do note that it may or it may never
reach the full 10 lines in Sheet2), then just freeze the results elsewhere
with a copy paste special values ok

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"ramana" wrote in message
oups.com...
Hi Max,

Thank you vermuch for the response, It could solve my problem
partially. I wanted to fill the column C fully satisfying the
condition and by changing the random values in the columns A & B.

Thanks & Regards

Ramana