Need To Complete Formular To Sort And Show Frequency

[travelersway]

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

I'd like to have Column B represent the sorted list without multiple
in decending order with no blank rows and Column C represent th
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 cel
otherwise the formula in B2 will be different from the formula in th
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 b
printed and this error message appears.
Is there a way to remove the error message?

Assistance appreciated.
Travelerswa

 

[swatsp0p]

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

B
=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

 

[travelersway]

Thank you very much. That did the trick.

Travelers wa