Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel mods
Message
From
08/12/1998 10:13:42
Joe Johnston
Suffolk, Virginia, United States
 
 
To
All
General information
Forum:
Visual C++
Category:
Other
Title:
Excel mods
Miscellaneous
Thread ID:
00165070
Message ID:
00165070
Views:
48
I need to get a column totaled. The prob is that its non standardized. If the cell is NOT
The pages have 3 columns ("UIC","NAME","VOLUNTEER") the pages represent regions, on all pages the first row is the title row. If the volunteer column on rows 2 and higher are NOT empty I want to add 1 to a grand total AND copy the UIC from that row to another page.

So if page 1 had 3 entries:
uic name Volunteer
abc joe X
qwe fred
wab mike x

And if page 2 had 5 entries:
uic name Volunteer
aer john y
bwn cindy y
jyb adam
ewn sandy y
jee anna

My total would be 5 and I would have a list like:
abc
wab
aer
bwn
ewn

If anyone has any ideas I would be most appreciative. Excel is not my bag. (until the boss came in this morning) [se la vie]
~Joe Johnston USA

"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams

Reply
Map
View

Click here to load this message in the networking platform