Microsoft Excel - need macro for data calculation

Asked By anu anu on 17-May-13 06:44 AM
hi ,

i need help for data calculation , i have one data with me in excel sheet like

Branch Item Description DESC  T Name sdsa sdsad Qty Unit Cost Total Cost Req ID  Consumption Dt  Mtr Reading Old Trn Date Old Consu. Dt Old Mtr Reading Actual Branch Serial No Model No PG Territory ASM MDS/NMDS Parent Name Customer Name DC/IDC Standard Yield Actual yield Diff in Yield Std. Used % Used % Status Ageing 
abc 454dfs12f tert y Black rtret 1-Apr-13 -1 3432 234 df 1-Apr-13 8797 6-Mar-13 6-Mar-13 53553 abc 324234 er p abc v  geeta dfgdf dfgdf r dfds dsfsd sdfd df -148% Below Used 61%~70%
abc ssdfsdf rt y Black trrtret 1-Apr-13 -1 34 34 dff 1-Apr-13 446       abc 234234 er p abc v  Neena   efsdf r dsf dsfsd df df -148% Above Used >100%
abc 45232345 ert y Black rtret 1-Apr-13 -1 324 234 as 1-Apr-13 64654 4-Mar-13 4-Mar-13 101477 abc 324 re p abc v  geeta werer werer r dfds dfds df df -148% Above Used >100%
abc sdfsdf erter y Black ret 1-Apr-13 -1 34 34 dsf 1-Apr-13 6546 17-Jan-13 17-Jan-13 638781 abc 423 re p abc v  Neena   sdfsdf r dsf df df df -148% Above Used >100%


i want ,above  data  calcultate in other sheet in like below.

    count of  above  used count of  Below  used
Branch MDS/NMDS Above Used Below Used Exactly used
np Neena 12 1  
geeta 1 4 2
np Total   13 5 2
xyz Neena 3 9 1
geeta 3 7 6
xyz Total   6 11 7
abc Neena 2 8 3
geeta 1 4 1
abc Total   3 13 4
Grand Total   14 4 13

thanks

anu

Matthew Johnson replied to anu anu on 17-May-13 10:12 AM
I just responded to your previous posting, but this is essentially a Pivot table.