count the nos and sum the same no and create summry based on datash pp.

[jay11]

hi
i have this module but it too slow is there way to do it speedily do this .

Please Login or Register  to view this content.

also here is the sample wb

[Richard Buttrey]

Hi,

Can you explain in a narrative with reference to your pp data how you are summarising it. i.e. what rules are you using.

I can't help thinking that standard Excel functionality might achieve the task in a much quicker way.

[jay11]

hi Richard Buttrey
in sh "pp" code should look in Column f find 1st instance says value 25.00 ,then in same column find next instance of value 25.00 count that instance and also sum that same ,then goto next value say 30.00 find value instance in column F and count and sum
so the summery sheet should look like following manner
value| sum|nos of occurrence |
25 |125 |5
30 |240 |8
50 |100 |2
.
.
.
so on all value in column G
hope i explain it
thanks

[jay11]

Hi,

Can you explain in a narrative with reference to your pp data how you are summarising it. i.e. what rules are you using.

I can't help thinking that standard Excel functionality might achieve the task in a much quicker way.

hi Richard Buttrey
in sh "pp" code should look in Column F find 1st instance says value 25.00 ,then in same column find next instance of value 25.00 count that instance and also sum that same ,then goto next value say 30.00 find value instance in column F and count and sum
so the summery sheet should look like following manner
value| sum|nos of occurrence |
25 |125 |5
30 |240 |8
50 |100 |2
.
.
.
so on all value in column G
hope i explain it
thanks

[jay11]

i found this code in forum and it some what work but the sorting the number in summary sh
not working any suggestion or any better solution are most appreciated .
thanks.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

I don't see values for 25 & 30 (A1&A2 in Summary)

Neither do I understand where values like 161.45 (B3) come from. I see that there are 5 occurencies of 37.14 (A3) but 5 x 37.14 = 185.7.
Please explain the calculations in column B

[jay11]

Hi,

I don't see values for 25 & 30 (A1&A2 in Summary)

Neither do I understand where values like 161.45 (B3) come from. I see that there are 5 occurrences of 37.14 (A3) but 5 x 37.14 = 185.7.
Please explain the calculations in column B

25 and 30 was just an example i was explaining how the number could came.
and i know column B need to have total but i can not code accordingly so i just multiply both nos. hear i attache new workbook u can find what i need to achieve by macro .i copy past two diff macro code from search,i do not know how to sort that from A2 to last row of sh"summary" so i did manually record macro and try to incorporate in to code.i know it's not perfect solution but that only i can came up with my proficiency of VBA.

per day    # of time    total 
0        52            0 
37.14       5            185.7 
37.15        2            74.3 
41.13        6            246.78 
41.14        13            534.82 
. 
. 
. 
.