How to arange and count various numbers in previous column

Try

=COUNTIF($A$1:$A$9,B1)...B1 = 2 etc

or

=COUNTIF($A$1:$A$9,2) ...change to next number

VBA Noob

Sorry,

Don't follow you

Example, I have one column of 9 cells; from A1 - A9

4
8
10
4
8
15
2
2
4

Now I need formula for column B to arrange different numbers that apperas in column A (sorted from the smallest)

Example

In column A smallest number that is in cells from A1 - A9 is 2. Cell B1 takes value 2, than follows number 4 ....

Than column B takes this values (B1 - B5)

2
4
8
10
15

Now I need a formula for column C so all numbers should be counted how many times they appears in column A

Number 2 appearS 2 times in cells A1-A9 and the value of cell C1 is 2. Number 4 appears 3 times and so on....

So column C is taking this values (C1 - C5)

2
3
2
1
1

I need this operation to be done by Excel, with different number of cells.

1). Sort numbers in Col A
2). In B1 enter =A1
3). Enter this array (ctrl + Shift + Enter) in B2. Change range to your range or look at dynamic ranges

=IF(ISERROR(MATCH(0,COUNTIF(B$1:B1,$A$1:$A$20&""),0)),"",INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH(0,COUNTIF(B$1:B1,$A$1:$A$20&""),0)))

4). Enter this in C1 and drag down

=COUNTIF($A$1:$A$9,B1)

http://www.contextures.com/xlNames01.html#Dynamic

http://www.bettersolutions.com/excel...L315812332.htm

HTH

VBA Noob

Does this help

VBA Noob

Glad it helped

VBA Noob