Dialogbox use Pivot or Array Forms?

[Guest]

I have tried to do this a number of times and keep getting lost in my code
after a couple of hours....
(A sample data set below!)

A giant list of data needs to have a number of operations done on it.

First, I must count the number of items in a column with an offset(x).value
= "Participation" within a range specified by t index.
Count # Participation put into array #Participating@T(t)

Then, a sum will start for each item in the column that will be based on the
place the item recieved and the number of items with the same date/time info.
1st ---> 16 / #(t), 2nd ---> 14 / #(t)...8th --> 2/#(t)
Only, items that have a place will be used for this sum(participation and
some special notes must be ignored).

Next, they all must be arranged into a list box that can be put on a list box.
0001 t1 1st
0001 t1 participated
0001 t1 special notes
0001 t2 8th
0001 t2 participated
0001 t3 6th
0001 t3 participated
0001 t5 2nd
0001 t5 participated
0001 t6 3rd
0001 t6 participated
0002 t2 participated
0002 t3 participated
0002 t5 6th
0002 t5 participated
0002 t7 8th
0002 t7 participated
0003 t4 2nd
0003 t4 participated

 

[Guest]

The general form for the final report should be
IndexItem#, Index2Item#, Item#, #ofTimesParticipation,
Sum(over all t)[PlaceScaler*#(t)] / (#timesParticipation)
--
This is some crazy buisness!

Scott Miller
University of Washington
Chemistry