Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Handling cells with multiple data entries
Hi,
I'm trying to create a histogram using bins 0 through 13 and data which looks like this: 13 1 6 1,4,11 1,3 12 1 10 1 2 4 The instances where there is a comma between entries are when there are multiple answers to the question. How do I tell Excel to count every entry in every cell for the histogram? Also, I've been trying to solve another histogram mystery and thus far no one on the message board has been able to help. I have data ranging from 0 through 8. I have bins 0 through 8. Yet when I enter this into the Histogram window, it gives me an output like this: Bin Frequency 0 1 1.142857143 21 2.285714286 7 3.428571429 5 4.571428571 7 5.714285714 6 6.857142857 1 More 10 First, what's with the decimals? And why "More" instead of "7" and "8"? Thanks! Emily |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to exclude all data except multiple entries? | Excel Discussion (Misc queries) | |||
Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
multiple entries-sums to different cells | Excel Worksheet Functions | |||
Handling "Blank Entries" through Data Validation | Excel Discussion (Misc queries) | |||
How do I group multiple data entries in sub-groups | Excel Worksheet Functions |