Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
perfoming calculation on randon cells
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
perfoming calculation on randon cells
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. -- Gary''s Student - gsnu200832 "Raja" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Randon selection of a value | Excel Discussion (Misc queries) | |||
perfoming ANOVA test | Excel Worksheet Functions | |||
how do i turn off calculation of cells | Excel Discussion (Misc queries) | |||
Randon number distribution/generator help please. | Excel Discussion (Misc queries) | |||
Randon file saves | Excel Discussion (Misc queries) |