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 [email protected] [email protected] New Delhi - 110062 On Tue, Apr 14, 2009 at 11:16 PM, Harmeet Singh <[email protected]>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 <[email protected]> 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 > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
