Hi Anmol, Task achieved. Solved sheet is also attached. Thanks
-- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 1, 2009 at 5:45 PM, Amol Shende <amo...@gmail.com> wrote: > Dear Friends, > > Pl help me to enter in the yellow cell the information from table 2 based > on the highlighted (red) date > > > > > *06/02/2009* ** ** *Date* *0 - 1 * *DURATION (Hrs.)* *No. of instances > * ** *06/01/09* 16 *0 - 1* *06/02/09* 8 *1 - 2* *06/03/09* 10 *2 > - 3* *06/04/09* 11 *3 - 4* *06/05/09* 6 *4 - 5* *06/06/09* 4 *5 > - 6* *06/07/09* 3 *6 - 9* *06/08/09* 6 *9 - 12* *06/09/09* 3 *> > 12* *06/10/09* 10 *TOTAL* *0* ** *06/11/09* 4 > > > > -- > With Warm Regards, > > Amol Balwant Shende, > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Match Data - Index-Match - By DILipandey.xls
Description: MS-Excel spreadsheet
