hi
i have this module but it too slow is there way to do it speedily do this .
also here is the sample wbPlease Login or Register to view this content.
hi
i have this module but it too slow is there way to do it speedily do this .
also here is the sample wbPlease Login or Register to view this content.
Last edited by jay11; 07-27-2015 at 11:53 AM.
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.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
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
Last edited by jay11; 07-27-2015 at 01:46 PM.
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
Last edited by jay11; 07-27-2015 at 01:46 PM.
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.
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
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.
PHP Code:
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
.
.
.
.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks