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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
