Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- Scott Miller University of Washington Chemistry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating Array from Pivot Table | Excel Worksheet Functions | |||
Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |