| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
generating list of data from frequencies
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
generating list of data from frequencies
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. "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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding up - number data and frequencies | Excel Discussion (Misc queries) | |||
| Generating a list | Excel Worksheet Functions | |||
| Generating list | Excel Worksheet Functions | |||
| graphing data of different frequencies | Charts and Charting in Excel | |||
| Converting between different frequencies for time series data | Excel Discussion (Misc queries) | |||
Linear Mode
