identify first occurnce of text in column

D

DJ Huff

See example below...

COL A COL B

document1 30
document1 45
document2 15
document1 33
document3 55
<blank> 32
document2 2
document1 42
document2 9
document3 44
etc...

I want a total for each document in a separate table, either on this same
sheet or on a separate summary worksheet. E.g.:

document1 total = 150
document2 total = 26
document3 total = 99
<balnk> total = 32

The kicker is that I don't want to specifically name the documents to
search, I want Excel to figure out the document names by searching down COL A
to the last occurance of information (may have to search COL B to find last
occurnace of information) and indicating what document names exist. Thus,
Excel would find document1 and place it and its total in a table, then find
document2 and place it in the row beneath document1 total in the table, etc.
If a routine must be developed, I would rther it be a Function than a
Procedure so it works dynamically.
 
D

DJ Huff

Thanks, but I want the table to reflect immediate changes, such as if I add a
document name where it was previously <blank>, yet with a $ amount. I did
create a pivot table and it showed me item counts rather than total $ amounts
for the document. I'll play more with pivot tables, but my first pass was
not impressive.
 
D

DJ Huff

I changed it to reflect $ amounts and that is fine...I just need it to
dynamically change rather than having to manually refresh it. How can I
automatically refresh this when an update to a row within the pivot table is
updated?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top