Re: $$Excel-Macros$$ Excel subtotaled worksheet

Hi Share an example workbook. Thx On Fri, Apr 18, 2014 at 5:19 AM, wrote: > How do I convert a subtotaled spreadsheet with 1000 lines into a short > list of only the totaled lines? > > -- > 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

$$Excel-Macros$$ Additional Control

To Whom It May Concern, May I ask, why can;t we click the additional Controls to create a new calender? Here is the image as below:- Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:R

$$Excel-Macros$$ Excel subtotaled worksheet

How do I convert a subtotaled spreadsheet with 1000 lines into a short list of only the totaled lines? -- 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 RUL

Re: $$Excel-Macros$$ Automating a goal seek using an excel formula

You can easily do so using the IRR function. You simply have to add your set NPV to the cashFlow at time 0 and look what your IRR is going to be. By definition, that irr is going to be the discount rate that permit you to obtain your set NPV. Le jeudi 21 juin 2012 05:21:40 UTC-4, ANKUR AGGARW

Re: $$Excel-Macros$$ Sort Dynamic range - Help needed

Hi PFA, result can be achieved using pivot table & dynamic reference. Thanks On Thu, Apr 17, 2014 at 2:25 PM, SG wrote: > Hi vabz, > > Thanks for the reply but this is not solving my purpose.The data is not > sorted on location & highest marks & i don't want to paste the visible data > anywhe

Re: $$Excel-Macros$$ Sort Dynamic range - Help needed

Hi vabz, Thanks for the reply but this is not solving my purpose.The data is not sorted on location & highest marks & i don't want to paste the visible data anywhere else. The sorting done only at that location i.e from colun A to D. On Thursday, April 17, 2014 2:02:46 PM UTC+5:30, Vabz wrote:

Re: $$Excel-Macros$$ Sort Dynamic range - Help needed

PFA Thx On Thu, Apr 17, 2014 at 1:28 PM, SG wrote: > > > Hi Experts, > > I need a solution to sort the data on basis of location & highest marks. > For this, i have created a dynamic named range to call it by macro & then > sort. My problem comes when the range also selects the blank formulas

$$Excel-Macros$$ Sort Dynamic range - Help needed

Hi Experts, I need a solution to sort the data on basis of location & highest marks. For this, i have created a dynamic named range to call it by macro & then sort. My problem comes when the range also selects the blank formulas in sheet which shouldn't be selected. Only visible data should s

Re: $$Excel-Macros$$ Login & password in excel

Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain wrote: > Dear Amar, > > Please see the attached file. I hope this works for you. > > You may login by using any of the following credentials (both username and > password fields are case se

$$Excel-Macros$$ get jobs update daily in MIS!!

login your facebook and Like this page if you are MIS professionals and Get Jobs update daily. https://www.facebook.com/misprofessionals Thanks! AK -- 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) ! Jo