View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DJ Huff DJ Huff is offline
external usenet poster
 
Posts: 3
Default identify first occurnce of text in column

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.

--
Regards,

DJ Huff, PhD, PMP, CISA, ITIL