Hi Marc..............

Check out Data Filter AutoFilter, and sort on your column to show all
non-blanks

Vaya con Dios,
Chuck, CABGx3


"Marc" wrote in message
...
I work at a crime laboratory and produce monthly stats on the types of
evidence analyzed. The master list is about a hundred items. Some are
encountered more than others. Does anyone know a function that will
return a
category if the value is greater than one and skip a category if it has a
zero value. This would be the montly report. I've tried using an IF
statement to no avail. Any help would be appreciated. Thanks in advance.