Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a chart of numbers that are grouped together
I have a group of numbers going from 1 - 10. I have them listed in 3 columns.
I am wondering if there is a way to show how often a number is listed with another number. Example Num1 Num2 Num3 ------ ------ ------ 1 2 3 2 4 1 5 8 3 1 2 5 9 10 6 From that I would like to make a column of 1 through 10, with each row having 1 through 10 as well. Then maybe having how often each number in the row was with the number in the column. This can be done with a Macro or some formula, if anyone can help I will make it work the way I am shown as I have no idea on how to do it. Example Main Row Num Number ----- -------------------------------------- 1 2 3 4 5 6 7 8 9 10 ----- -------------------------------------- 1 3 2 1 2 1 0 0 0 0 0 ----- -------------------------------------- 2 2 3 1 1 0 1 0 0 1 0 ----- -------------------------------------- Thank You. David |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a chart of numbers that are grouped together
Is this in the right forum or should it be moved to another? Any assistance
is appreciated. David "David" wrote: I have a group of numbers going from 1 - 10. I have them listed in 3 columns. I am wondering if there is a way to show how often a number is listed with another number. Example Num1 Num2 Num3 ------ ------ ------ 1 2 3 2 4 1 5 8 3 1 2 5 9 10 6 From that I would like to make a column of 1 through 10, with each row having 1 through 10 as well. Then maybe having how often each number in the row was with the number in the column. This can be done with a Macro or some formula, if anyone can help I will make it work the way I am shown as I have no idea on how to do it. Example Main Row Num Number ----- -------------------------------------- 1 2 3 4 5 6 7 8 9 10 ----- -------------------------------------- 1 3 2 1 2 1 0 0 0 0 0 ----- -------------------------------------- 2 2 3 1 1 0 1 0 0 1 0 ----- -------------------------------------- Thank You. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a chart | Excel Discussion (Misc queries) | |||
Creating a chart with text not numbers | Charts and Charting in Excel | |||
Making a chart that uses a secondary Y axis | Charts and Charting in Excel | |||
Making chart with hidden Data | Excel Discussion (Misc queries) | |||
Sorting values in a bar chart | Charts and Charting in Excel |