Combination Needed in Excel Sheet...,

[rajuctech]

Hi Guys,
Will you please suggest me, how i can get the combination using different type of filters in the below said method

<table style="width: 510px; height: 183px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 51pt;" width="68"> <col style="width: 62pt;" width="83"> <col style="width: 68pt;" width="90"> <col style="width: 89pt;" width="119"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl69" style="height: 15.75pt; width: 51pt;" width="68" height="21">Region</td> <td class="xl69" style="border-left: medium none; width: 62pt;" width="83">Product</td> <td class="xl69" style="border-left: medium none; width: 68pt;" width="90">Customer Type</td> <td class="xl69" style="border-left: medium none; width: 89pt;" width="119">Sales Person - Name</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="height: 15.75pt; border-top: medium none;" height="21">North</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Glue Guns</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Enterprise</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Chewbacca</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">East</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Light Sabres</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Galaxy</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Hansolo</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">West</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Transponders</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Planet</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">James Kirk</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">South</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">All Products</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">All Customers</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Luke Skywalker</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">All Regions</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">All Sales persons</td> </tr> </tbody></table>like below mentioned guys

<table style="width: 434px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col width="240"><tbody><tr height="17"> <td class="xl65" style="height: 12.75pt; width: 180pt;" width="240" height="17">WestGlue GunsPlanetChewbacca</td> </tr></tbody></table>
<table style="width: 134px; height: 83px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 12.75pt;" height="17"><td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17"><table style="width: 336px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col width="240"><tbody><tr height="17"> <td class="xl65" style="height: 12.75pt; width: 180pt;" width="240" height="17">WestTranspondersGalaxyJames Kirk

Thanks in Advance
</td> </tr></tbody></table> </td><td valign="top">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;">
</td></tr></tbody></table>

 

[shg]

There's a workbook that does this at http://www.box.net/shared/ubd28tissi

 

[rajuctech]

Hi Many thanks

Best Regards,
Raju

 

[shg]

You're welcome, hope it helps.

 

[rajuctech]

Hi can you plz suggest the
"combination serious with count also"
ex:below said method...........,suggest

<table border="0" cellpadding="0" cellspacing="0" width="421"><col style="width: 268pt;" width="357"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 268pt;" width="357" height="20">COMBINATION </td> <td class="xl63" style="border-left: medium none; width: 48pt;" width="64">Count</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products All Customers All</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products All Customers Chewbacca</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products All Customers Hansolo</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products All Customers James Kirk</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products All Customers Luke Skywalker</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Enterprise All</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Enterprise Chewbacca</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Enterprise Hansolo</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Enterprise James Kirk</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Enterprise Luke Skywalker</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Galaxy All</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Galaxy Chewbacca</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Galaxy Hansolo</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Galaxy James Kirk</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Galaxy Luke Skywalker</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Planet All</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; border-top: medium none;" height="20">All RegionsAll Products Planet Chewbacca</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">





</td> </tr> </tbody></table>

 

[rajuctech]

hi please anyone help ............................................................................

Advance thanks
raju

 

[rajuctech]

hi how to capture the data..............................................
please.............. help me,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

 

[rajuctech]

hi i am wondering none of them given the conclusion mu query ,it's big tragedy how many expert people is there in the Mr Excel Team am not beliveeeeeeeeeeeeeeeeeeeeeee................................................................