$$Excel-Macros$$ formula help

2018-11-17 Thread Kamal Ganeshan
Dear All, I have attached one files need your help to applied correct formula Kindly help. Regards, Ganeshan -- 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

$$Excel-Macros$$ Excel experts- Help require on

2018-04-18 Thread Kamal Ganeshan
Hi everyone, Hope all is well, Can you please help on the below requirement. *Requirement*: I need formula or VBA code which split to each code sequence which is highlighted in yellow colour. Eg: *Z020- Z026* = Z020 | Z021 | Z022 | Z023 | Z024 | Z025 | Z026 Code 1 2 3 4 5 6 7 Z005-Z006 Z005

$$Excel-Macros$$ How to apply validation in Open office 3.1

2015-01-10 Thread Kamal Ganeshan
Hi All, Can you please help me to apply validation in Open Office 3.1 Regards, Ganeshan -- 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$$ Need help to create a user form.

2014-11-11 Thread Kamal Ganeshan
Hi All, Need some help to create a User form based on the logic. If any enter Sub Brand numbers in cell F12 Invoice number in cell G12 then I want the H should be update automatic as per the above table numbers. I have done the exercise which is manual Vlookup formula but i need the same logic

Re: $$Excel-Macros$$ Need help to create a user form.

2014-11-11 Thread Kamal Ganeshan
2 90121 97013 0 90121 90124 1 Regards, Ganeshan On Wed, Nov 12, 2014 at 11:23 AM, Kamal Ganeshan ganesh.theva...@gmail.com wrote: Hi All, Need some help to create

$$Excel-Macros$$ Only Excel formuala

2014-08-25 Thread Kamal Ganeshan
Hi Friends, Can anyone help me with the excel formula for the attached list of question Regards, Ganeshan -- 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$$ Only Excel formuala

2014-08-25 Thread Kamal Ganeshan
Awesome, Appreciate a lot for really good information. Regards, Ganeshan On Tue, Aug 26, 2014 at 1:39 AM, Pramod Singh pramod...@gmail.com wrote: Hi Kamal Ganeshan Please find the attached file i cheersss Regards Pramod On Tue, Aug 26, 2014 at 12:16 AM, Kamal Ganeshan

Re: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns

2011-07-12 Thread kamal ganeshan
Just follow few steps below data=import External Data = select the ftxt file option then select the txt file and press alt +d + e (text to colums)delimited and click on other and next other option one box is given just press shift + \ it will show you this | and then next and finish txt file