View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Bill is offline
external usenet poster
 
Posts: 390
Default Randomly Generate Specific Data

FB1
FB2
FB3 00 01 02 03 04 05
FB4 0
C1 1
C2 2
C3 3
C4 4
PO 5
PO1
PO2
PO3
CU1
CU2
CU3
CU4
I have created a random generator to place the data on the left into the
chart above. I would like to add a percentage stop, ie: CU4 is only 7% of
the data in the chart.
I would then like to create another grid that places the row and column
numbers associated with the data. ie: if if 022 is FB1, I would like FB! to
be placed in another chart that shows how many of each data point has been
placed.

Help?