M
MJ
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!
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!