Grüezi vividpresence

vividpresence schrieb am 24.05.2004

Date Member ID Attendance

1/1 44444 checked in
1/1 55555 checked in
1/1 66666 canceled
1/3 44444 checked in
1/3 55555 canceled
1/3 66666 canceled
1/4 44444 checked in
1/4 55555 cecked in
1/4 66666 canceled
1/6 44444 Cheked in
1/6 55555 canceled
1/6 66666 checked in

44444 would be 100%
55555 would be 50%
66666 would be 25%

You could use a pivot-table.

Set the cellmarker in your data-range -- Menu: 'Data' -- Pivot-Table..
-- [Continue] -- Range: (should be marked now, otherwise dot it by
yourself) -- [Continue] -- [Layout..] -- Drag the field 'Member ID'
from the right side of the window to the 'Rows'-area and the field
'Arrendance' once to the 'Columns'-area and once to the 'Data'-area.

Now doubleclick the field 'Attendance' in the 'Datas'-area -- [Options...]
-- Show as: '% of Row' -- [OK] --[OK] -- [Finish]

All your Member-IDs now are listed with their %-amont of each
attendance-code

--
Regards

Thomas Ramel
- MVP for Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]