hi Dilip,
firstly i will be copying the pivot table from task distribution sheet.
Row Labels Sum of # of no hits DEEPTI 45 LAKSHMI 35 NIKHIL 46 PUSHPA
15 RAVI 7 SAI 35 VENKAT 46 ARVIND 21 Grand Total 250
this part from task distribution sheet and click on extension bar (+) to get
the individual line items for all.
then place the name which is listed on the top of the batch against their
respective lineitems .
like this .........
Row Labels Sum of # of no hits DEEPTI 45 3 1 4 2 6 1 8 1 9 1 11 1
12 1 15 2 292 1 300 2 301 1 302 2 304 2 305 1 418 10 561 2 562 1
573 3 574 5 735 1 742 4 LAKSHMI 35 288 6 394 5 420 2 422 6 429 1
564 2 565 7 569 1 737 5 NIKHIL 46 289 3 293 6 306 1 396 6 397 3
424 4 425 4 427 3 566 4 571 4 576 4 739 4 PUSHPA 15 287 10 295 5
RAVI 7 285 4 286 3 SAI 35 296 4 297 3 298 1 398 6 399 3 423 5 568
1 572 5 578 5 740 2 VENKAT 46 284 13 290 2 308 2 309 2 311 1 416 4
421 5 563 8 570 3 736 6 ARVIND 21 16 3 283 3 299 2 307 1 395 3 419
1 428 5 430 1 741 2 Grand Total 250
here the first column is Batch # and second column is their number of hits.
After this ill do vlookup in the sheet where the data is pasted .
comparing the task distribution sheet orginal with Task distribution sheet.
1) ill take batch number from task distribution orginal sheet which is in
column c as Lookup value.
and table array as the data pasted in new sheet earlier.(pivot table
data which is pasted using paste special and then assigned names to it)
and Purpose of this vlook is to know get the pending batches billers names.
those batches which are left in task distribution sheet that batches as well
as their names should appear.
Please advise is it possible. it could be very much helpful.
Thanks,
Raj
On Tue, Oct 12, 2010 at 4:37 PM, Dilip Pandey <dilipan...@gmail.com> wrote:
> Dear Rakasekhar.
>
> I am not able to understand your problem actually... :(
> How you are assigning the names against tasks ?
>
> I believe creating a pivot table and then using "Show Pages" option
> you can assign the tasks to different individuals.
>
> Please explain further if you need some other solution.
>
> Best Regards,
> DILIPandey
>
>
>
> On 10/9/10, rajasekhar praharaju <rajasekhar.prahar...@gmail.com> wrote:
> > could you please assist me in this concern .please
> >
> > actually if any batch is pending using vlookup i used to find their
> > respective names
> > how is this possible through sumif please suggest .
> >
> > On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS <svyas0...@gmail.com> wrote:
> >
> >> Dear Rajasekhar
> >>
> >>
> >> Please use u Sumif Formulas.
> >>
> >> Regards
> >>
> >> Sumit Vyas
> >>
> >>
> >>
> >> On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju <
> >> rajasekhar.prahar...@gmail.com> wrote:
> >>
> >>>
> >>>
> >>> hi Excel Guru,
> >>>
> >>>
> >>> Please assist me in this concern .
> >>>
> >>>
> >>> Attached are two sheets Task distribution orginal and other sheet with
> >>> task distribution
> >>>
> >>>
> >>> My daily activity is to do vlookup and firstly i will copy the pivot
> >>> table
> >>> from task distribution sheet orginal and paste special in one new excel
> >>> sheet then compare it with another sheet which is task distribution
> >>> sheet.
> >>>
> >>>
> >>> 1) Prepare vlookup to find the batches which are pending .
> >>>
> >>>
> >>> once i perform vlookup it will display the names against the batches.
> >>> which are pending .
> >>>
> >>>
> >>> Please advise is this possible through vba.
> >>>
> >>>
> >>> Thanks for your help in advance.,
> >>>
> >>> Raj
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>>
> >>>
> ----------------------------------------------------------------------------------
> >>> Some important links for excel users:
> >>> 1. Follow us on TWITTER for tips tricks and links :
> >>> http://twitter.com/exceldailytip
> >>> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>>
> >>> To post to this group, send email to excel-macros@googlegroups.com
> >>>
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> Like our page on facebook , Just follow below link
> >>>
> >>>
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> >>>
> >>
> >> --
> >>
> >>
> ----------------------------------------------------------------------------------
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >>
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> >>
> >
> > --
> >
> ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
