I have doubts about whether you can arrive at this with any certainty. I am assuming the channels are some sort of broadcast channels. Perhaps TV or Radio channels. CCG is ambiguous. It could mean Canadian Coast Guard or perhaps Central Control Government or dozens of other things.
The problem is that you do not know which of 2 channels a particular user will be using at the time of the impression. This means that a user who is common between A and E may see 75,000 impressions on Channel E or may see 250,000 on Channel A. You will need to draw up a list of assumptions to be built into any algorithm, such as - if a user is common to 2 channels that user is assumed to use each channel 50% of the time. This assumption would allow you to eliminate the overlapping users (You would subtract 5 users from Channel A and 5 from Channel E. There may be other issues, particularly with regards to the users with access to 3 or more channels. The above assumption eliminates these. However it may unfairly impact the low usage channels (such as E) because these seem to have disproportionate cross channel overlaps. If you want to give a bit more information, particularly about what the terms "CCG", "Channel", and "Impression" mean, it may be feasible for me or another member (ideally a statistician) to help you further. Regards David Grugeon On 10 May 2013 13:47, Sri Jai <jaisri1...@gmail.com> wrote: > Dear Experts, > > Need your help on the below.... > > Attached is an example that uses sample figures from Channels A, B and C > form the spreadsheet > > The example assumes that there is an overlap between all three channels > (A, B and C) because we know that there is an overlap between A&B, A&C and > B&C. > > I have attached a diagramatic representation and a word document > > Can i write a macro on the attached to eliminate the overlap and just have > the actual numbers across multiple columns a,b and c ..... for now and even > future if the values changes in future......Thanks a ton for the help in > advance > > > Sri > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.