$$Excel-Macros$$ Excel calculating repayment and interest

2014-10-09 Thread Falina Gan
To Whom It May Concern, May I ask how do you calculate the table that show per-attachment especially on the principle repayment and interest? We hope to hear from you soon. Thanks. Regards, Falina -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT

Re: $$Excel-Macros$$ Calculating Number of Context Changes in a Series

2014-10-09 Thread jlobrien222
Thank you so much, Paul! That worked perfectly! I very much appreciate your quick help! On Thursday, October 9, 2014 1:51:57 PM UTC-5, Paul Schreiner wrote: > > I'm sure there are LOTS of approaches to this, > but using simple Excel functions, I went with this approach: > > Assuming: > From:

Re: $$Excel-Macros$$ Report

2014-10-09 Thread joseph camill
Hi Vaibhav, Yes, I tried this, and it is working great. I have made one modification. Instead of right click to the workbook, I added a Form control button and have assigned to it. Need to add more sheets and do a final check. On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi wrote: > Joseph >

Re: $$Excel-Macros$$ Calculating Number of Context Changes in a Series

2014-10-09 Thread Paul Schreiner
I'm sure there are LOTS of approaches to this, but using simple Excel functions, I went with this approach: Assuming: From: time is in row 1 To: time is in row 2 Data begins in row 3 I added a blank column at column B to show that that at the start of the day, no task is being worked on. I

$$Excel-Macros$$ Calculating Number of Context Changes in a Series

2014-10-09 Thread jlobrien222
Hello! I have a spreadsheet of time tracking data. Each row is a different activity and members are tracking time to that activity by entering an "x" for each 15 minute interval that they completed that activity. I would like to calculate per task, how many times they started and stopped that

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Kanwaljit Singh Dhunna
Have a Look ! I hope you are aware of how to enter an Array Formula ! On Thu, Oct 9, 2014 at 9:07 PM, Sundarvelan N wrote: > Friends. > > I tried all your suggestions i did not got the answer > > Thanks > N.Sundarvelan > 9600160150 > > On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna < >

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Sundarvelan N
Friends. I tried all your suggestions i did not got the answer Thanks N.Sundarvelan 9600160150 On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna wrote: > Hi, > > Assuming yours values are in range A1:A10, you need to enter the following > as an Array Formula > > =MAX(--RIGHT(A1:A10,8)) >

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Kanwaljit Singh Dhunna
Hi, Assuming yours values are in range A1:A10, you need to enter the following as an Array Formula =MAX(--RIGHT(A1:A10,8)) To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter after entering the formula in the Cell. On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap wrote: > Hi

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread manu kashyap
Hi Frd, =max(substitute(cellvalue ya cell reference,"IT","",1)) Try kro bhai On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: > Dear Friends, > > Please help me in finding the maximum value in a non numeric column, > example below > > Answer needed is IT20140010 > > > IT20140001 IT20140002 IT2

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Ahmed Honest
use a helper column to convert the data (to numeric) and then apply Max formula you shall get the answer.. Hope this helps​ On Thu, Oct 9, 2014 at 3:54 PM, Sundarvelan N wrote: > Dear Friends, > > Please help me in finding the maximum value in a non numeric column, > example below > > A

$$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Sundarvelan N
Dear Friends, Please help me in finding the maximum value in a non numeric column, example below Answer needed is IT20140010 IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 IT20140007 IT20140008 IT20140009 IT20140010 Thanks N.Sundarvelan 9600160150 -- Are you =EXP

Re: $$Excel-Macros$$ Report

2014-10-09 Thread joseph camill
Hi Vaibhav, Thank you for the file and apologies for the late response. It is working great. Thanks and regards, Joseph Camill On Tue, Oct 7, 2014 at 10:51 AM, Vaibhav Joshi wrote: > JC > > check this, > > there is sheet name C, in that mention InputSheet Names in col A & > OutPutsheet name

Re: $$Excel-Macros$$ Sort VBA required

2014-10-09 Thread Ganesh N
Hi amar, PFA. Regards, Ganesh N On Thu, Oct 9, 2014 at 11:52 AM, amar takale wrote: > Dear Sir > > Pls find attached another sheet for detailed clarification.Here I show > how to look output will show.Bos there are same one stock are under > different category. > > Like BHEL it show under both

Re: $$Excel-Macros$$ Port VBA code to VB.net

2014-10-09 Thread Anil Gawli
Dear Rupesh, Pls share the file. Warm Regards, Gawli Anil. On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil wrote: > Hello Expert, > > In my organization we have developed VBA Application for doctors. now we > want to create .exe file of this application > so as per my knowledge we can't create .ex

$$Excel-Macros$$ Port VBA code to VB.net

2014-10-09 Thread Rupesh Patil
Hello Expert, In my organization we have developed VBA Application for doctors. now we want to create .exe file of this application so as per my knowledge we can't create .exe file of VBA application. so we need to port this code to .net. Could please assist me how to do this. -- Thanks & Rega

Re: $$Excel-Macros$$ Job Opening for MIS profile.

2014-10-09 Thread Suman
Hi Pramod! Would you please help to send the venue with JD (Job Discretion)?​ *Suman Kumar* On Wed, Oct 8, 2014 at 10:34 AM, Pramod Singh wrote: > Hi All. > > I have also one Opning in my company. As MIS profile. > > Salary 19 k and pickup and drop and also meals . > > Regards > Pram