$$Excel-Macros$$ hlep me

2014-11-11 Thread 'Anil Kumar' via MS EXCEL AND VBA MACROS
how to use function show all location by country name pfa Regards, Anil Kumar Maurya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Help Vlookup function duplicate

2014-11-11 Thread 'Anil Kumar' via MS EXCEL AND VBA MACROS
Hi friends, pfa please help me only  vlookup function use find duplicate value.  Regards,Anil Kumar Maurya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: split text by pipe sign

2014-11-04 Thread 'Anil Kumar' via MS EXCEL AND VBA MACROS
Hi Sanjay use this function =IF(COLUMN()-2=0,IFERROR(LEFT($A18,FIND(|,$A18)-1),$A18),IFERROR(MID($A18,FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-2))+1,IFERROR(FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-1))-1,LEN($A18))-FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-2))),)) Regards, Anil Kumar Maurya

Re: $$Excel-Macros$$ How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

2014-11-04 Thread 'Anil Kumar' via MS EXCEL AND VBA MACROS
Hi pfa Regards, Anil Kumar Maurya On Tuesday, 4 November 2014 4:50 PM, M.Rafique MRU imrafiqu...@gmail.com wrote: Dear Excel Experts! Hi, Once again I need your help regarding subject matter, mentioned above. I need Data of 527 employees data on other sheet

$$Excel-Macros$$ MIS Executive

2014-10-25 Thread 'Anil Kumar' via MS EXCEL AND VBA MACROS
Hi All i am search job for Sr. MIS Executive any jop please sent me. anilmaurya...@gmail.com Thanks Regards Anil Kumar Maurya Mob. 8882545343 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @