Distribution the number

[MAHMOUD-LEE]

How can the distribution of the numbers in the table ?

			Distribution the number
num	Distribution		1
1	20		1
2	22		1
3	15		1
4	14		1
5	16		1
			1
			1
			1
			1
			1
			1
			1
			1
			1
			1
			1
			1
			1
			1
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			2
			3
			3
			3
			3
			3
			3
			3
			3
			3
			3
			3
			3
			3
			3
			3
			4
			4
			4
			4
			4
			4
			4
			4
			4
			4
			4
			4
			4
			4
			5
			5
			5
			5
			5
			5
			5
			5
			5
			5
			5
			5
			5
			5
			5
			5

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[markmzz]

Hi Markmzz,

I guess that's pretty much the same as mine except that I've now started using this INDEX construct with ROW. Makes it a bit longer and a few more function calls, but guards against row insertions (and doesn't use INDIRECT), so perhaps worth it?

Also, if there are any blanks in the range B2:B6, then e.g. 0+$B$2:$B$6 will prevent the formula from erroring.

Cheers

Like I said "a small modification".

Lets wait for the user.

By the way, use Ctrl+Shift+Enter to enter the formula (I forgot that in my previous post).

Markmzz