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


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=390906

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?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=390906

Thank you very much. That did the trick.

Travelers way


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=390906