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
Bookmarks