Hi Cheechu & "Dear Group Frnds" You can download the "FileFormatConverter"/"Compatibility pack of Office 2007" from Microsoft website to open files created with Office 2007. I do have this tool, but because of huge Size, which is 28,192KB I am not able to send it to you.
-- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/5/09, Chechu <cecic...@hotmail.com> wrote: > > > Hi Mahesh, > > I was not able to open your file since I'm with Excel 2003. Please, > could you save as 2003 and re send? If you can have sheet 1 sorted > ascending, I think that you could use Vlookup without "TRUE" argument > at the end. > > Thanks, > Chechu > > On Sep 5, 4:07 am, Mahesh <mahender.bi...@gmail.com> wrote: > > Dear Firends, > > > > need ur help here. > > > > i want to enter number in sheet 2 and want to match it in sheet 1 > > if the same number is not in the sheet 1 then it will find the nearest > > number either +1 or -1. > > > > Please check the attached sheet. > > > > -- > > With Love, > > Mahesh Bisht > > > > Book1.xlsx > > 15KViewDownload > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
