perfoming calculation on randon cells

  • Thread starter Thread starter Raja
  • Start date Start date
R

Raja

What I would like to do is if I have a list of data in my spreadsheet and I
choose randomly some cells I want to see what the result would be for these
numbers that I selected. Let's say I want to see 10 % of any cells that I
select!!
 
Say you have formulas in column A from A1 thru A1000 and want to view 20 of
these at random.

In Y1 thru Y1000 enter 1 thru 1000
In Z1 thru Z1000 enter =rand()

Now for the sample. In D1, enter:
=Y1 and copy down thru D20

In E1, enter:
=OFFSET($A$1,D1-1,0) and copy down thru E20

Now sort cols Y & Z by Z.
Cols D & E will represent the rows being sampled and the value in the
sampled cell.
 
Back
Top