PivotTable would my choice, see
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

and place the criteria fields in the Page Field/Report Filter



--
Regards
Dave Hawley
www.ozgrid.com
"Judi" wrote in message
...
I have a spreadsheet which is about 1500 rows long. There are about a
total
of 150 people on it, with duplicates. Each person had a listing for each
piece of desktop software they currently have on his/her system.

The header line is as follows:
Name Org CompName Property# Software/Program

Version Licensed (Y/N) If Licensed, artifact or proof (describe) Comments

It obviously goes all the way across. My boss wants to see a breakdown (I
think a pivot table will be the best way to go about it) based first on
the
Program, then the version, and then whether it's licensed or not.

The problem is that not all fields have a value, so the pivot table may
not
be the way to go. Can anyone throw out some ideas of how to best present
this? I thought of doing just a custom sort first by program, version,
and
then license. But I think there has to be a nicer way to present this
data.

Thanks so much!!!

Judi