This ONE line formula should go in table!b2 and be copied across. Hope this
gets you started.
=SUMPRODUCT((Calculation!$A$2:$A$6000=$A$1)*(Calculation!$C$2:$C$6000={"incident","Service
Request"})*(Calculation!$D$2:$D$6000=B$1))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Atul vishwakarma
Sent: Sunday, December 11, 2011 10:53 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Need a Macro To Generate Tables with Statistical
Calculations
Hi Experts,
Till now I did not get any update for below mentioned problem. I need help for
the below requirement I and I require urgently. I am attaching Sample Excel
file to understand the requirement.
Thanks!
Regards,
Atul
On Sun, Dec 11, 2011 at 3:31 PM, Atul <atulkuma...@sify.com> wrote:
Dear Friends,
I have an excel data on first sheet with 4 columns and need to be
generate tables on second sheet according to given format as below
conditions.
There should be 4 different tables on sheet named "Table" according to
Priority (1-Critical, 2-Urgent, 3-Normal & 4-Medium)
There are two type of Data Classification (Incident & Service Request)
And in each table "Count" should be for both incident and service
request but other all values (P50, P95, P75, Mean, Min, Max, Span and
Tr.Mean) should be only for Incident.
P50 is 50% Percentile
P95 is 95% Percentile
P75 is 75% Percentile
Span is Difference of Max and Min (Span = Max - Min)
Tr. Mean is TRIMMEAN 10% (For This I used formula as
=TRIMMEAN("array", 0.1)
Now My Problem is that I have to get tables according values in 4th
Column "Number"
On Second sheet all calculation should be according to Number 1 to 4
1 to 4 I have given as sample, It can be more
I need a macro which will generate all 4 tables on second sheet
according to priority and Number.
Sample values I have given for Number 1
Please revert to me for any clarification.
But I don't know How to attach Sample excel file here.
Thanks!
Regards,
Atul
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
