generating list of data from frequencies
From Excel HELP
The result of the REPT function cannot be longer than 32,767 characters, or
REPT returns #VALUE!.
"kalik00" wrote:
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?
|