generating list of data from frequencies

  • Thread starter Thread starter kalik00
  • Start date Start date
K

kalik00

I have a frequency matrix for numeric categories. Some of the frequencies are
very large (1000s) and I want to generate a list of data with the category
value repeated the number of times it occurs in the data set (i.e. if "5" is
category and frequency is 1543 then I want 1,543 "5"s in a column. Any ideas?
 
If your category is in A1 and frequency in B1 then enter this in C1
=REPT(TEXT(A1,"@"),B1)
and copy down... It will work subject to maximum characters in a cell.
 
From Excel HELP

The result of the REPT function cannot be longer than 32,767 characters, or
REPT returns #VALUE!.
 
Back
Top