Hi Floks,
I am by no means a excel wizard but I am looking for
something/function/macro that help a bit.

Name Document URL Disposition
Directory: test
mem_b.gif http:/ /rural/mem_b.gif Archive
tree_b.gif http:// /rural/tree_b.gif Archive
search.html http:// /rural/search.html Archive
jobapp.html http:// /rural/jobapp.html Archive
interm.html http:// /rural/interm.html High
interdiscintro.html http:// /rural/interdiscintro.html High
mem.html http:// /rural/mem.html Low

I have many spreadsheets (with many more coming) with data looking
something like the above (a export of some program that list directory
structures on a Linux box) I have blanks and another non-sense in the
data. What I would like to do is look is:
1) look at column A for file name extensions
2) generate a unique like of extensions such as gif, html, jpg etc. I
don't know what the extensions will be but I need to generate counts.
3) from the list of extensions summarize how many extensions are of
what type. For example I need to know how many gifs, are archive, low,
high or Re-assigned status (there are only 4 possible types).

Thanks,
Chris

I've posted a workbook at http://cjoint.com/?lpw125nEnw, see if this helps

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Floks,
> I am by no means a excel wizard but I am looking for
> something/function/macro that help a bit.
>
> Name Document URL Disposition
> Directory: test
> mem_b.gif http:/ /rural/mem_b.gif Archive
> tree_b.gif http:// /rural/tree_b.gif Archive
> search.html http:// /rural/search.html Archive
> jobapp.html http:// /rural/jobapp.html Archive
> interm.html http:// /rural/interm.html High
> interdiscintro.html http:// /rural/interdiscintro.html High
> mem.html http:// /rural/mem.html Low
>
> I have many spreadsheets (with many more coming) with data looking
> something like the above (a export of some program that list directory
> structures on a Linux box) I have blanks and another non-sense in the
> data. What I would like to do is look is:
> 1) look at column A for file name extensions
> 2) generate a unique like of extensions such as gif, html, jpg etc. I
> don't know what the extensions will be but I need to generate counts.
> 3) from the list of extensions summarize how many extensions are of
> what type. For example I need to know how many gifs, are archive, low,
> high or Re-assigned status (there are only 4 possible types).
>
> Thanks,
> Chris
>

Hi Bob,
Tried to pm you but I must have done it wrong. This is exactly what
I am looking for! Is there away to automate?
Chris


On Nov 15, 4:54 pm, "Bob Phillips" <bob....@xxxx.com> wrote:
> I've posted a workbook athttp://cjoint.com/?lpw125nEnw, see if this helps
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> <cmang...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
> > Hi Floks,
> > I am by no means a excel wizard but I am looking for
> > something/function/macro that help a bit.
>
> > Name Document URL Disposition
> > Directory: test
> > mem_b.gif http:/ /rural/mem_b.gif Archive
> > tree_b.gif http:// /rural/tree_b.gif Archive
> > search.html http:// /rural/search.html Archive
> > jobapp.html http:// /rural/jobapp.html Archive
> > interm.html http:// /rural/interm.html High
> > interdiscintro.html http:// /rural/interdiscintro.html High
> > mem.html http:// /rural/mem.html Low
>
> > I have many spreadsheets (with many more coming) with data looking
> > something like the above (a export of some program that list directory
> > structures on a Linux box) I have blanks and another non-sense in the
> > data. What I would like to do is look is:
> > 1) look at column A for file name extensions
> > 2) generate a unique like of extensions such as gif, html, jpg etc. I
> > don't know what the extensions will be but I need to generate counts.
> > 3) from the list of extensions summarize how many extensions are of
> > what type. For example I need to know how many gifs, are archive, low,
> > high or Re-assigned status (there are only 4 possible types).
>
> > Thanks,
> > Chris