I have several excel spreadsheets that list the contents of a drive by
file name, path, size of file, extension and a few other things. I can
sort the file extension column to see a general list of the files of
each type but I was wondering if there is a simple way to (1) list all
the different file extensions that I have in a column and (2) count
them up and list that number. It's almost like a summary report which
would appear like this:


Extension Number of docs
..doc 446
..ppt 103
..htm 734

etc. etc. etc.

I can always clean up the sheet but am not sure how to accomplish this
and it would be a neat trick!

Hi
use a picottable for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"MJ" <lawSPAMyer@newsS_PA_Mguy.com> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> I have several excel spreadsheets that list the contents of a drive
by
> file name, path, size of file, extension and a few other things. I
can
> sort the file extension column to see a general list of the files of
> each type but I was wondering if there is a simple way to (1) list
all
> the different file extensions that I have in a column and (2) count
> them up and list that number. It's almost like a summary report which
> would appear like this:
>
>
> Extension Number of docs
> .doc 446
> .ppt 103
> .htm 734
>
> etc. etc. etc.
>
> I can always clean up the sheet but am not sure how to accomplish
this
> and it would be a neat trick!

SUPERB!!!!! THANK YOU!!!!!

On Mon, 13 Sep 2004 18:43:35 +0200, "Frank Kabel"
<(E-Mail Removed)> wrote:

>http://www.cpearson.com/excel/pivots.htm
>http://peltiertech.com/Excel/Pivots/pivotstart.htm
>http://www.contextures.com/xlPivot02.html
>http://www.ozgrid.com/Excel/excel-pivot-tables.htm