I have data as follows
<table border="0" cellpadding="0" cellspacing="0" width="642"><col style="width: 61pt;" width="81"> <col style="width: 57pt;" width="76"> <col style="width: 74pt;" width="99"> <col style="width: 76pt;" width="101"> <col style="width: 75pt;" width="100"> <col style="width: 48pt;" width="64"> <col style="width: 46pt;" width="61"> <col style="width: 45pt;" width="60"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 61pt;" height="20" width="81">Date</td> <td class="xl65" style="width: 57pt;" width="76">Objective Code</td> <td class="xl65" style="width: 74pt;" width="99">Account Name</td> <td class="xl65" style="width: 76pt;" width="101">Activity Details</td> <td class="xl65" style="width: 75pt;" width="100">Sales Type</td> <td class="xl65" style="width: 48pt;" width="64">Product Name</td> <td class="xl65" style="width: 46pt;" width="61">Amount</td> <td class="xl66" style="width: 45pt;" width="60">Time Spent</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">02/04/2011</td> <td>bq</td> <td>Kalpataru</td> <td>met the GM of par division</td> <td>prospect</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">2.30</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>
</td> <td>Internal</td> <td colspan="2" style="">Databse Cleanup</td> <td>
</td> <td>
</td> <td class="xl68" align="right">3.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>
</td> <td>Marva DG</td> <td colspan="3" style="">meeting with Sarma's team members</td> <td>
</td> <td class="xl68" align="right">6.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>bq</td> <td>Exxon</td> <td>research, email, couriered collateral</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">2.15</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>bq</td> <td>Exxon</td> <td>Spoket to GM, IT secy Radhika</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.50</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/04/2011</td> <td>sk</td> <td>Fairtel</td> <td>Made initial proposal</td> <td>proposal</td> <td>Ksoft</td> <td align="right">225000</td> <td class="xl68" align="right">6.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/04/2011</td> <td>sk</td> <td>Fairtel</td> <td>Made initial proposal</td> <td>proposal</td> <td>Ksoft</td> <td>
</td> <td class="xl68" align="right">4.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/06/2011</td> <td>bq</td> <td>IM CG</td> <td>Call</td> <td>First Call</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">2.50</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/06/2011</td> <td>np</td> <td>GGE</td> <td>conference call</td> <td>lead</td> <td>
</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/07/2011</td> <td>bq</td> <td>Kalpataru</td> <td>followup call with GM's sec for appmnt</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/07/2011</td> <td>bq</td> <td>GGL Sanyo</td> <td>Invoice made & courued IN 2086</td> <td>Invoice</td> <td>Brand Q</td> <td align="right">75000</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/08/2011</td> <td>bq</td> <td>GGL Sanyo</td> <td>Invoice made & courued</td> <td>Invoice</td> <td>Ksoft</td> <td align="right">45000</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/08/2011</td> <td>sn</td> <td>Internal</td> <td colspan="2" style="">Travel to Delhi for meeting MJ</td> <td>
</td> <td>
</td> <td class="xl68" align="right">20.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/10/2011</td> <td>bq</td> <td>Marva DG</td> <td>Follow up with Kajaria</td> <td>Lead</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/10/2011</td> <td>bq</td> <td>Internal</td> <td colspan="2" style="">setup for SMS campaign</td> <td>
</td> <td>
</td> <td class="xl68" align="right">7.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/11/2011</td> <td>
</td> <td>Internal</td> <td colspan="2" style="">evaluate sms vendors</td> <td>
</td> <td>
</td> <td class="xl68" align="right">30.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/12/2011</td> <td>sm</td> <td>Fairtel</td> <td>follow up on proposal</td> <td>proposal</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.25</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/12/2011</td> <td>np</td> <td>GI Constructions</td> <td>Meeting with Case workers Pranav & Hanuman</td> <td>Lead</td> <td>
</td> <td align="right">80000</td> <td class="xl68" align="right">4.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/12/2011</td> <td>sk</td> <td>BP Battery</td> <td>quote for licences sent</td> <td>proposal</td> <td>Ksoft</td> <td align="right">55000</td> <td class="xl68" align="right">2.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Kalpataru</td> <td>followup call with GM's sec for appmnt</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Kale</td> <td>Invoice made & courued IN 2086</td> <td>Invoice</td> <td>Brand Q</td> <td align="right">15000</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Viveka soft</td> <td>prospect call resrach etc</td> <td>prospect</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">2.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Big Catch</td> <td>prospect call, research etc</td> <td>prospect</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">3.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>sk</td> <td>GGL Sanyo</td> <td>Support provided for usage</td> <td>Support</td> <td>Ksoft</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/15/2011</td> <td>sk</td> <td>Internal</td> <td colspan="2" style="">Review meeting with MK</td> <td>
</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/17/2011</td> <td>sk</td> <td>Viveka Soft</td> <td>First call to Sudhir's office</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.10</td> </tr> </tbody></table>------------------------------------------------------------------
I need a formula that picks rows and groups by account name and puts in separate sheet. It must be a formula not pivot table stuff. Vlookup does only unique data. Can any one help please??
regards
<table border="0" cellpadding="0" cellspacing="0" width="642"><col style="width: 61pt;" width="81"> <col style="width: 57pt;" width="76"> <col style="width: 74pt;" width="99"> <col style="width: 76pt;" width="101"> <col style="width: 75pt;" width="100"> <col style="width: 48pt;" width="64"> <col style="width: 46pt;" width="61"> <col style="width: 45pt;" width="60"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 61pt;" height="20" width="81">Date</td> <td class="xl65" style="width: 57pt;" width="76">Objective Code</td> <td class="xl65" style="width: 74pt;" width="99">Account Name</td> <td class="xl65" style="width: 76pt;" width="101">Activity Details</td> <td class="xl65" style="width: 75pt;" width="100">Sales Type</td> <td class="xl65" style="width: 48pt;" width="64">Product Name</td> <td class="xl65" style="width: 46pt;" width="61">Amount</td> <td class="xl66" style="width: 45pt;" width="60">Time Spent</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">02/04/2011</td> <td>bq</td> <td>Kalpataru</td> <td>met the GM of par division</td> <td>prospect</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">2.30</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>
</td> <td>Internal</td> <td colspan="2" style="">Databse Cleanup</td> <td>
</td> <td>
</td> <td class="xl68" align="right">3.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>
</td> <td>Marva DG</td> <td colspan="3" style="">meeting with Sarma's team members</td> <td>
</td> <td class="xl68" align="right">6.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>bq</td> <td>Exxon</td> <td>research, email, couriered collateral</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">2.15</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">03/04/2011</td> <td>bq</td> <td>Exxon</td> <td>Spoket to GM, IT secy Radhika</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.50</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/04/2011</td> <td>sk</td> <td>Fairtel</td> <td>Made initial proposal</td> <td>proposal</td> <td>Ksoft</td> <td align="right">225000</td> <td class="xl68" align="right">6.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/04/2011</td> <td>sk</td> <td>Fairtel</td> <td>Made initial proposal</td> <td>proposal</td> <td>Ksoft</td> <td>
</td> <td class="xl68" align="right">4.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/06/2011</td> <td>bq</td> <td>IM CG</td> <td>Call</td> <td>First Call</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">2.50</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/06/2011</td> <td>np</td> <td>GGE</td> <td>conference call</td> <td>lead</td> <td>
</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/07/2011</td> <td>bq</td> <td>Kalpataru</td> <td>followup call with GM's sec for appmnt</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/07/2011</td> <td>bq</td> <td>GGL Sanyo</td> <td>Invoice made & courued IN 2086</td> <td>Invoice</td> <td>Brand Q</td> <td align="right">75000</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/08/2011</td> <td>bq</td> <td>GGL Sanyo</td> <td>Invoice made & courued</td> <td>Invoice</td> <td>Ksoft</td> <td align="right">45000</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/08/2011</td> <td>sn</td> <td>Internal</td> <td colspan="2" style="">Travel to Delhi for meeting MJ</td> <td>
</td> <td>
</td> <td class="xl68" align="right">20.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/10/2011</td> <td>bq</td> <td>Marva DG</td> <td>Follow up with Kajaria</td> <td>Lead</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/10/2011</td> <td>bq</td> <td>Internal</td> <td colspan="2" style="">setup for SMS campaign</td> <td>
</td> <td>
</td> <td class="xl68" align="right">7.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/11/2011</td> <td>
</td> <td>Internal</td> <td colspan="2" style="">evaluate sms vendors</td> <td>
</td> <td>
</td> <td class="xl68" align="right">30.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/12/2011</td> <td>sm</td> <td>Fairtel</td> <td>follow up on proposal</td> <td>proposal</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.25</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/12/2011</td> <td>np</td> <td>GI Constructions</td> <td>Meeting with Case workers Pranav & Hanuman</td> <td>Lead</td> <td>
</td> <td align="right">80000</td> <td class="xl68" align="right">4.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/12/2011</td> <td>sk</td> <td>BP Battery</td> <td>quote for licences sent</td> <td>proposal</td> <td>Ksoft</td> <td align="right">55000</td> <td class="xl68" align="right">2.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Kalpataru</td> <td>followup call with GM's sec for appmnt</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Kale</td> <td>Invoice made & courued IN 2086</td> <td>Invoice</td> <td>Brand Q</td> <td align="right">15000</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Viveka soft</td> <td>prospect call resrach etc</td> <td>prospect</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">2.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>bq</td> <td>Big Catch</td> <td>prospect call, research etc</td> <td>prospect</td> <td>Brand Q</td> <td>
</td> <td class="xl68" align="right">3.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/13/2011</td> <td>sk</td> <td>GGL Sanyo</td> <td>Support provided for usage</td> <td>Support</td> <td>Ksoft</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/15/2011</td> <td>sk</td> <td>Internal</td> <td colspan="2" style="">Review meeting with MK</td> <td>
</td> <td>
</td> <td class="xl68" align="right">1.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" align="right" height="20">04/17/2011</td> <td>sk</td> <td>Viveka Soft</td> <td>First call to Sudhir's office</td> <td>prospect</td> <td>
</td> <td>
</td> <td class="xl68" align="right">0.10</td> </tr> </tbody></table>------------------------------------------------------------------
I need a formula that picks rows and groups by account name and puts in separate sheet. It must be a formula not pivot table stuff. Vlookup does only unique data. Can any one help please??
regards
