Re: $$Excel-Macros$$ find and remove text

2013-06-07 Thread Rahul Sharma
la > > =LEFT(G10,FIND("-",G10)-1) > > > > . > > Enjoy > Team XLS > > > > On Fri, Jun 7, 2013 at 12:13 PM, Rahul Sharma > > > wrote: > >> hi folks, >> i need a formula that can find the text string an

$$Excel-Macros$$ find and remove text

2013-06-06 Thread Rahul Sharma
hi folks, i need a formula that can find the text string and remove from the name. i have 1500 name stored in my data, i presently i am doing manually, which is lengthy process. example Guru Kirpa Distributor,Bathinda Guru Kirpa Spare Centre,Jalandhar Guru Kripa Distributor-(Bathinda-Pb.) Gu

$$Excel-Macros$$ Re: Need formula based on 3 condition

2013-01-16 Thread Rahul Sharma
hello suyog, please try this :- =+IF((B2+12)>B4,(B7+B10),IF((B2+12)B4:B5,((B5-B2+12)*(B8/12) On Friday, January 11, 2013 3:18:13 PM UTC+5:30, Suyog Kulkarni wrote: > > Hello All, > > Please see attached excel, I'm confused how can I set IF statement based > on varying 3 condition for one c

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

2012-10-26 Thread Rahul Sharma
link is not working. On Friday, October 26, 2012 11:49:46 AM UTC+5:30, Rahul Sharma wrote: > > Hi All, > > Firstly let me thanks to the admin and all the members for > their wonderful job which they are contributing in this great forum. I have > learnt a lot from all of

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

2012-10-26 Thread Rahul Sharma
product will appear. On Friday, October 26, 2012 11:49:46 AM UTC+5:30, Rahul Sharma wrote: > > Hi All, > > Firstly let me thanks to the admin and all the members for > their wonderful job which they are contributing in this great forum. I have > learnt a lot from all of you. > &

$$Excel-Macros$$ Need a Function on Multiple drop down list

2012-10-25 Thread Rahul Sharma
your information. Do the needful, Thanks Rahul Sharma -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

$$Excel-Macros$$ Re: Introduce Yourself !!

2012-09-21 Thread Rahul Sharma
Hi Everyone, Rahul Sharma from New Delhi, working in Maharaja Whiteline Industris Ltd. On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of excel Fans! > >