Dynamic Counts based on different conditions
 

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

Dynamic Counts based on different conditions
 

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)

wrote in message
ups.com...
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

Dynamic Counts based on different conditions
 

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" 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)

wrote in oglegroups.com...

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