$$Excel-Macros$$ Re: Find the Number

2009-09-06 Thread Mahesh
Thanx man, u all ppls are just awesome. double thumbs up for u .. On Sun, Sep 6, 2009 at 2:43 PM, jonell wrote: > On Sep 5, 5:07 pm, Mahesh 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 numbe

$$Excel-Macros$$ Re: Find the Number

2009-09-06 Thread jonell
On Sep 5, 5:07 pm, Mahesh 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 Lo

$$Excel-Macros$$ Re: Find the Number

2009-09-05 Thread Dilip Pandey
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

$$Excel-Macros$$ Re: Find the Number

2009-09-05 Thread Chechu
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 wrote: > Dear Firends, >