Column A is a list of numbers that will be manually entered, processed,
and replaced by new data repeatedly.
I'd like to have columns B and C represent the sorted list in desending
order and the frequency of occurrences for each value in A

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

I'd like to assure columns B and C have no blank rows.

Can this be done without manual operations?

Help is appreciated.

Travelersway


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