Concatenate values from large to small, in hierarchical order

Hello,

I am looking to concatenate values in a range and place them in a cell seperated by a dash in hierarchical order, largest to smallest. The range of numbers is from 0-9 and some of the cells in the range are empty so they should be disregarded. For example, if in a range of FD4:FM4,

FD4:is blank
FE4: 1
FF4: blank
FG4: 3
FH4: 2
FI4: 2
FJ4: 1
FK4: blank
FL4: blank
FM4: blank

The concatenated cell should be 3-2-2-1-1.

Another example would be, if

FD4: 1
FE4: 1
FF4: blank
FG4: 1
FH4: 1
FI4: 1
FJ4: 1
FK4: blank
FL4: 1
FM4: blank

the concatenated cell should be 1-1-1-1-1-1.

Thank you for your time,
Sans

If the range is always 10 cells then try:

Please Login or Register  to view this content.