Re: $$Excel-Macros$$ queary

Hi Anil Assuming cell A1 = 901+k then in cell B1 try below formula =LOOKUP(MID(A1,FIND("+",A1,1)+1,1),{"a","i","k","l","p";"b","d","a","e","c"}) HTH Mahesh On Thu, May 24, 2012 at 8:58 PM, NOORAIN ANSARI wrote: > Dear Anil, > > Please try it and see attached sheet. > > * > =IF(COUNTIF($B$3:B

Re: $$Excel-Macros$$ queary

Dear Anil, Please try it and see attached sheet. * =IF(COUNTIF($B$3:B3,LEFT(B3,3)&"*")>1,VLOOKUP(LEFT(B3,3)&"*",$B$2:C3,2,0),CHAR(96+COUNTA($B$3:B3))) * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote

Re: $$Excel-Macros$$ queary

Dear Anil, Please try it.. *=CHAR(96+ROW(A1)) * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote: > Hello friends, > > I have a queary plz find attahcment. > > > Thanks & Regards > Anil > > -- > FORUM

Re: $$Excel-Macros$$ queary

: excel-macros Subject: $$Excel-Macros$$ queary Hello friends, I have a queary plz find attahcment. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

Re: $$Excel-Macros$$ queary

sorry sir, lack of time i could not explen. I gat data in 901+k 903+a 901+p 905+i 902+l I have to change 901+k=a, 901+a=b, k=a a=b p=c i=d l=e -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

Re: $$Excel-Macros$$ queary

Dear Anil, Please explain..what you want as output. On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote: > Hello friends, > > I have a queary plz find attahcment. > > > Thanks & Regards > Anil > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread tit

Re: $$Excel-Macros$$ queary

what query u have , from the attachment i didn't understand . On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote: > Hello friends, > > I have a queary plz find attahcment. > > > Thanks & Regards > Anil > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accura

$$Excel-Macros$$ queary

Hello friends, I have a queary plz find attahcment. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get q

$$Excel-Macros$$ queary about translate

Hi Friends, I have a excel file which have data in hindi, I have to translate in english, there is any softwear or way to solve my problem plz tell me. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

RE: $$Excel-Macros$$ queary about filter

Find here http://www.hindisociety.com/HindiFonts.htm From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Tue/2012 04:53 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ queary about filter Hello sir, fist of

Re: $$Excel-Macros$$ queary about filter

Hello sir, fist of all thanks, were can i gat hindi verson of excel. anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

Re: $$Excel-Macros$$ queary about filter

Dear Anil, your need to install a hindi language version of excel to show hindi. the filter drop down shows the true character in the cell same thing happens if you format as windings. On Tue, Jan 17, 2012 at 4:10 PM, anil kumar wrote: > Hello group members, > > I have a excel file which have d

$$Excel-Macros$$ queary about filter

Hello group members, I have a excel file which have data in hindi, I have to short by add. can I use filter or any other way plz tell me. Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Karan, that's great yaar !!! ] On Wed, Oct 19, 2011 at 9:48 AM, karan 1237 wrote: > Hey Anil, > > Convert your image files in excel through online or download a software > from the website below : > > http://www.onlineocr.net/ > > > http://www.cometdocs.com/ > > > http://www.coolutils.com/O

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hi karan and ashis, Thanks for your soon reply. Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ h

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Anil, Convert your image files in excel through online or download a software from the website below : http://www.onlineocr.net/ http://www.cometdocs.com/ http://www.coolutils.com/Online-Excel-Converter.php http://document.online-convert.com/convert-to-pdf http://www.pdfconverter.com/

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

http://www.onlineocr.net/ try any orc to excel or word converter software or online websites On Tue, Oct 18, 2011 at 6:01 PM, anil kumar wrote: > > > Hi Karan, > > first of all thanks. you have solved my problem. but how i can > > -- > >

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hi Karan, first of all thanks. you have solved my problem. but how i can -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our L

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Anil, Please find enclosed. Kaяan