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? |
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) |