| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Frequency Question -- Please Help
I have a grid of numbers.
I want to create a new grid which has corresponding frequencies for the original grid. In other words, if A1 = 10, and my data spreads from A1 to G100, then I want A1 of the new grid to = how many times 10 appears in the A1 to G100 dataset. Anyone know how to do this without having to create a histogram and manually matching my numbers with the histogram's frequencies? My dataset is becoming too large to do all that matching (and I make errors after my eyes go buggy). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
| Pivot table question | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| 3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
| Frequency for Histograms in Excel | Charts and Charting in Excel | |||
Threaded Mode
