To keep your data automatically sorted when changes occur, you will need a
VBA macro.

HTH
--
AP

"Air_Step" a écrit dans le message de
...
I have a spreadsheet that counts the number of times certain things appear
on
another page and list them all out together. What I end up with is a list
of
names (all the departments in the company) and the number of persons who
are
currently "in" that department.

It looks like this

Medical 0
Finance 2
Admin 3
Car Wash 0
Publications 0
Reception 4
Maintenance 1
IT 2

Etc.

What I need is to have the list automatically trimmed to remove those
lines
that don't have a number against them, and sort them into number order.
So
the above would look like this:

Reception 4
Admin 3
Finance 2
IT 2
Maintenance 1

This is fairly easy to arrange 'manually' - ie sorting the list, but can I
get it to occur automatically, as the original list is itself being
updated
from another data source?

Thanks in advance for any assistance.

Air_Step