counting multible numbers

[Andycouch]

Hi all,
I am very new. But here is my question.
I want to set up a grid. 1-10 across and 1-10 down. That part I got.
Now I want to look at a table that has numbers. for example 1,5,8. all in different cells. on the next row it may have 1,5,6. So what I want to do on this grid is show how many time 1,5 are together. in this case 1 and 5 appear 2 times. 1 and 8 appear 1 time. like below.
1 2 3 4 5 6 7 8 9 10
1 0 0 0 2 1 0 1 0 0
2 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0
4 0 0 0 0 0 0 0 0 0 0
5 2 0 0 0 1 0 0 1
6 1 0 0 0 1 0 0 0 0 0
7
8 1 0 0 0 1 0 0 0 0 0 0
9
10

So what is the best way to do this?
Thanks for your patients and help.
Andy

 

[T. Valko]

ok I will try to explain it this way. Look at the grid below. Example I need a formula that will in cell F3 count the data of 1,5,8 and 1,5,6 and return the number 2 because the 5 and 1 show up 2 times in the data. This is the best way I can explain it and I hope it helps. I wish I knew more about how to copy and past from excel to here but It would not transfer.
Thanks again for all the help and patients.

<TABLE cellSpacing=0 cellPadding=0 width=217 border=0><COLGROUP><COL style="WIDTH: 14pt" width=19><COL style="WIDTH: 14pt" span=11 width=18><TBODY><TR style="HEIGHT: 12pt" height=16><TD class=xl70 style="WIDTH: 14pt; HEIGHT: 12pt" width=19 height=16>1</TD><TD class=xl65 style="WIDTH: 14pt" width=18>A</TD><TD class=xl65 style="WIDTH: 14pt" width=18>B</TD><TD class=xl65 style="WIDTH: 14pt" width=18>C</TD><TD class=xl65 style="WIDTH: 14pt" width=18>D</TD><TD class=xl65 style="WIDTH: 14pt" width=18>E</TD><TD class=xl65 style="WIDTH: 14pt" width=18>F</TD><TD class=xl65 style="WIDTH: 14pt" width=18>G</TD><TD class=xl65 style="WIDTH: 14pt" width=18>H</TD><TD class=xl65 style="WIDTH: 14pt" width=18>I</TD><TD class=xl65 style="WIDTH: 14pt" width=18>J</TD><TD class=xl65 style="WIDTH: 14pt" width=18>K</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>2</TD><TD class=xl66></TD><TD class=xl67 style="BORDER-LEFT: medium none">1</TD><TD class=xl67 style="BORDER-LEFT: medium none">2</TD><TD class=xl67 style="BORDER-LEFT: medium none">3</TD><TD class=xl67 style="BORDER-LEFT: medium none">4</TD><TD class=xl67 style="BORDER-LEFT: medium none">5</TD><TD class=xl67 style="BORDER-LEFT: medium none">6</TD><TD class=xl67 style="BORDER-LEFT: medium none">7</TD><TD class=xl67 style="BORDER-LEFT: medium none">8</TD><TD class=xl67 style="BORDER-LEFT: medium none">9</TD><TD class=xl67 style="BORDER-LEFT: medium none">10</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>3</TD><TD class=xl67 style="BORDER-TOP: medium none">1</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">2</TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">1</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">1</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>4</TD><TD class=xl67 style="BORDER-TOP: medium none">2</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>5</TD><TD class=xl67 style="BORDER-TOP: medium none">3</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>6</TD><TD class=xl67 style="BORDER-TOP: medium none">4</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>7</TD><TD class=xl67 style="BORDER-TOP: medium none">5</TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">2</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>8</TD><TD class=xl67 style="BORDER-TOP: medium none">6</TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">1</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">1</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>9</TD><TD class=xl67 style="BORDER-TOP: medium none">7</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>10</TD><TD class=xl67 style="BORDER-TOP: medium none">8</TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">1</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl69 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">1</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>11</TD><TD class=xl67 style="BORDER-TOP: medium none">9</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl70 style="HEIGHT: 11.25pt" height=15>12</TD><TD class=xl67 style="BORDER-TOP: medium none">10</TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl68 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD></TR></TBODY></TABLE>

Well, I don't understand so I'll move on.

 

[Andycouch]

T. Valko,
Thanks for the help. I really wish I could get an example posted the way you guys wanted but I could not get it to work. My last post I tried to get it to show what I wanted it to in the cell. Anyway thanks for trying.
Hope you have a great weekend.
Thanks
Andy

 

[shg]

All you have to do is copy the data in Excel in the usual way (Ctrl+C) and paste it into your post.

 

[Andycouch]

Every time I do that I do not get the grid. I have tried that about 10 times and it just shows the numbers I have in the different cells.

 

[shg]

You could post the file on a file sharing site (box.net is my preference) and post a link.

 

[Andycouch]

Ok I did that here it is http://www.box.net/shared/lxrd5ma05m

What I want is for the cell F3 and B7 to show 2 because 1 and 5 happen together 2 times. from the list below the grid. Also It would show in cell I8 and G10 that 8 and 6 happen together 1 time.