Need To Complete Formular To Sort And Show Frequency

Column A is a list of numbers that will be manually entered, processed and replaced frequently.

I'd like to have Column B represent the sorted list without multiples in decending order with no blank rows and Column C represent the frequency of occurences for each value in A.


A....B....C
5....3....2
3....4....3
4....5....1
4.....*
3.....*
4.....*


* represents error message


MORRIGAN has offered the following formulas that perform well.
Again, Thank You Morrigan.

Assume row 1 is your header, A2:A7 is the data

B2 = SMALL(A$2:A$7,1+SUM(C$1:C1))
C2 = COUNTIF(A$2:A$7,B2)

C1 can be blank but CANNOT be a number. C1 is used as a helper cell otherwise the formula in B2 will be different from the formula in the rest of the cells in column B.

I have a problem with my data. Row B shows an error message ( #NUM! ) in empty cells not used. All the cells are assigned to a form to be printed and this error message appears.
Is there a way to remove the error message?

Assistance appreciated.
Travelersway

Untested, but you could use error trapping to return a blank cell, e.g.:

B2 =IF(ISERROR(SMALL(A$2:A$7,1+SUM(C$1:C1)),"",SMALL(A$2:A$7,1+SUM(C$1:C1))

Does this work for you?