Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data

2013-11-16 Thread xlstime
attachment missing . Enjoy Team XLS On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma wrote: > Dear experts, > > > I am unable to write the formula for the attached excel file. > Please help me to create formula please..i have tried many a times, but > unable to w

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Rajan sharma
Dear Sirs, I want to find the Closest match from A and D column. i mean if the word contains in A column similar to D column (it may be 1st , 2nd or any middle line or last line) then the closest matches should be lookup. I hope i could able to explain you all experts, Thanks to all for

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Anil Gawli
Dear rajan, Pl elaborate more on this query Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Nov 14, 2013 at 11:57 AM, Rajan sharma wrote: > Dear all experts, > > Is my query is valid ? can we lookup the closes

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Ashish Kumar
Dear Ranjan, Are You want delete all the rows which contain orange data in column E. in sheet one. Thanks, Ashish On Thursday, 14 November 2013, Rajan sharma wrote: > Dear all experts, > > Is my query is valid ? can we lookup the closest data as like the > attachment earlier. Please h

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Rajan sharma
Dear all experts, Is my query is valid ? can we lookup the closest data as like the attachment earlier. Please help on the attachment. Thanks to all. With warm regards, Rajan Sharma On Thu, Nov 14, 2013 at 9:49 AM, Rajan sharma wrote: > Sorry- attachment missed > Dear experts, > > >

$$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Rajan sharma
Sorry- attachment missed Dear experts, I am unable to write the formula for the attached excel file. Please help me to create formula please..i have tried many a times, but unable to write. I have elaborate my query in the file itself. Please please find the attachment. Thanks a ton

$$Excel-Macros$$ Formula require for Conditional and Lookup data

2013-11-13 Thread Rajan sharma
Dear experts, I am unable to write the formula for the attached excel file. Please help me to create formula please..i have tried many a times, but unable to write. I have elaborate my query in the file itself. Please please find the attachment. Thanks a ton in advance. With warm reg