Re: $$Excel-Macros$$ formula into one row, data from oracle

2013-02-24 Thread zoelkondoi
Thanks Anil, For your quick response, but on your suggestion only single row, i want the formula can handle entire row below (description and receipt number column) thanks a lot Pada Senin, 25 Februari 2013 14:36:56 UTC+8, अनिल नारायण गवली menulis: > > Dear Iskandar, > > Pl see the attache

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

2013-02-24 Thread zoelkondoi
Hallo my name Iskandar Zulkarnain, 38 years old, male, i am from Indonesia and i work as asset control, i'm using excel, powerpoint and EAM in my work. iskandar.zulkarnai...@gmail.com FB : kondoi7...@yahoo.co.id twitter @zoelkondoi Pada Sabtu, 09 Juni 2012 3:21:59 UTC+8, Ayush Jain menulis: > >

Re: $$Excel-Macros$$ How to hide formula in cell......?

2013-02-24 Thread Ashish Kumar
Dear Gawli, Thanks..!!! On Monday, February 25, 2013 11:56:55 AM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Kumar, > > First select the desired cell. right click on that select format cells > there goto protection tab. > uncheck all the options and again rightclick on that cell goto > for

Re: $$Excel-Macros$$ How to hide formula in cell......?

2013-02-24 Thread Ashish Kumar
Dear Yahya & Anil, My query is resolved, Thanks for the support. Thanks, Ashish Kumar On Monday, February 25, 2013 11:47:48 AM UTC+5:30, Yahya Muhammad wrote: > > > > Dear Kumar > > Please see below link. > > http://www.techonthenet.com/excel/cells/hide_formulas2007.php > > > > >

Re: $$Excel-Macros$$ How to hide formula in cell......?

2013-02-24 Thread अनिल नारायण गवली
Dear Kumar, First select the desired cell. right click on that select format cells there goto protection tab. uncheck all the options and again rightclick on that cell goto formatcells,protection tab check the hidden option and goto review and protect the sheet . on protect sheet uncheck the very

Re: $$Excel-Macros$$ How to hide formula in cell......?

2013-02-24 Thread Yahya Muhammad
Dear Kumar Please see below link. http://www.techonthenet.com/excel/cells/hide_formulas2007.php On Mon, Feb 25, 2013 at 9:09 AM, kumar.ashish861 wrote: > Hi Group, > > I want to hide a formula in cell. then, what should i do for this. plz > provide solution for the same. > > > > Thanks > As

$$Excel-Macros$$ How to hide formula in cell......?

2013-02-24 Thread kumar.ashish861
Hi Group, I want to hide a formula in cell. then, what should i do for this. plz provide solution for the same. Thanks Ashish -- 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.

Re: $$Excel-Macros$$ Formula for Loan amount

2013-02-24 Thread Excel_Lover
Hi, See if it will help you, Regards, On Tue, Feb 19, 2013 at 9:37 AM, L.K. Modi wrote: > Brother I want to know about the formula with the data i had provided so > pls give exact solution. > > > > > > > -- Forwarded message -- > From: pankaj sangotra > Date: Tue, Feb 19, 201

$$Excel-Macros$$ Re: Compare two text columns by last name

2013-02-24 Thread satyas
Thanks Nitin. On Saturday, February 23, 2013 4:40:33 PM UTC+5:30, Nitin Gupta wrote: > > Pls see the solution in attached sheet > > Nitin > > On Saturday, February 23, 2013 1:14:46 PM UTC+5:30, satyas wrote: >> >> >> Hi Experts, >> >> Just need to compare two columns by last name . Will appreciate