Dilip, How can u read my mind. awesome...... On Wed, Apr 15, 2009 at 3:51 PM, Dilip Pandey <dilipan...@gmail.com> wrote:
> Rightly said Harmeet, > > Because if the file is not attached, then we have to do "Data Clensing" & > "Data Processing"... and it involves considerable time dedication, which > will ultimately restrict and shorten our time that can be utilised to give > solutions to others... right harmeet?? > > Pls attach the file. Thanks > bye.. > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > On Tue, Apr 14, 2009 at 11:16 PM, Harmeet Singh > <harmeet.hew...@gmail.com>wrote: > >> Can you send a file instaed of rich text. >> >> would be easy to understand >> >> On Tue, Apr 14, 2009 at 9:05 PM, Kumar <phanikumar...@gmail.com> wrote: >> >>> >>> I Have an Excel Sheet which Contains the Following : >>> >>> DEPT Name Employee Name Emp Code Month Period From >>> Period To Place >>> From Place To Journey Fare D.A Conveyance- Exp Misc. Exp >>> Mum ABC 18647 JAN 21/01/2009 02/02/2009 Mumbai >>> Chennai 2500 1800 1500 >>> 800 >>> Mum ABC 18647 FEB 23/01/2009 28/01/2009 GOA >>> Kochi 1400 1250 1400 400 >>> Mum ABC 18475 FEB 26/01/2009 29/01/2009 Mumbai >>> Chennai 1400 1700 750 >>> 950 >>> Chennai DEF 18742 JAN 21/01/2009 02/02/2009 Mumbai >>> Chennai 2400 1450 >>> 658 350 >>> Mum ABC 18647 Jan 21/01/2009 02/02/2009 Mumbai >>> Chennai 2500 1800 1500 >>> 800 >>> HQ Arabin 18648 JAN 06/02/2009 13/02/2009 HYD >>> Banglore 2600 2150 2342 >>> 1250 >>> HQ Arabin 18648 JAN 08/02/2009 12/02/2009 Banglore >>> Delhi 2700 2500 >>> 3184 1700 >>> HQ Arabin 18648 JAN 09/02/2009 12/02/2009 HYD >>> Banglore 2800 2850 4026 >>> 2150 >>> >>> In the Above Scenario, The Employee ABC Claims the Tour Bill twice and >>> in >>> between the dates, So I need to know which Employee is Claiming Twice >>> and >>> claiming in between Dates ... here there may be ABC with in Different >>> Dept >>> with Different Emp. Code... So If any one can Help me i will be >>> Thankful... >>> >>> >>> >>> >> >> >> -- >> Thanks & Regards, >> >> Harmeet Singh >> >> >> > > > > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
