Re: $$Excel-Macros$$ Combo box properties gone invisible

2015-01-09 Thread Vaibhav Joshi
Try re-installing OS.. Cheers!! On Wed, Jan 7, 2015 at 12:01 PM, Pavan Chowdary pavansai.vall...@gmail.com wrote: Hi All, This is Pavan. I have a file which contains forms combo boxes. After installing recent windows updates, i am unable to see combo boxes properties and getting visual

Re: $$Excel-Macros$$ Need help with formula:(

2015-01-09 Thread Vaibhav Joshi
Hi You can do it using function sumifs Share sample data in excel sheet if you need further help.. Cheers!! ᐧ On Fri, Jan 9, 2015 at 7:39 PM, Janani Rajagopalan uthr...@gmail.com wrote: I have the below data. I want to dynamically sum the Value column when the CID and FID are the same and

Re: $$Excel-Macros$$ Worksheet Function

2015-01-09 Thread Eugene Bernard
Thank you Mr Paul, for the detailed explanation. I missed to include the keyword Range and the Quotes. It works now. Regards Eugene On Fri, Jan 9, 2015 at 12:58 AM, Paul Schreiner schreiner_p...@att.net wrote: OK, In your macro, you're trying to the use the Subtotal worksheet function.

$$Excel-Macros$$ Very urgent need of Build Release Engineer with TFS and Powershell experience. Immediate interview.

2015-01-09 Thread Mazhar Khan
Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Build Release Engineer with TFS and Powershell experience**. **Chevy Chase, MD* . Please find below the job description for the same and revert back to me with your consultant updated

$$Excel-Macros$$ Very urgent need of Scrum Master with Telecom Industry experience and Scrum Master Certified.

2015-01-09 Thread Mazhar Khan
Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Scrum Master**. San Ramon, CA/Middletown, NJ *. Please find below the job description for the same and revert back to me with your consultant updated profile and contact details at the

$$Excel-Macros$$ Subtotal mystery

2015-01-09 Thread Deepak Rawat
HI friends, pls find attached there are 2 subtotals, there is difference coming in both on same values pls clarify how it is happening? Regards, Deepako -- 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

Re: $$Excel-Macros$$ Subtotal mystery

2015-01-09 Thread Vaibhav Joshi
Hi Deepak, Output is correct..In column E there is no subotatled row in the range E2 to E29, hence you are getting sum insted of subtotal.. There shud be subottaled column whose amt is not added back by subtotal function why summing up value in range, it is present in range C2 to C29 D2 to D29

Re: $$Excel-Macros$$ Subtotal mystery

2015-01-09 Thread Paul Schreiner
The problem is that your East Total, North Total, South Total, West Total and AP total are all subtotals. You would not include these subtotals when you calculate your Grand Total, or you'd be counting them twice! But in your column E, you are replacing the subtotals with values. So, in this

$$Excel-Macros$$ Need help with formula:(

2015-01-09 Thread Janani Rajagopalan
I have the below data. I want to dynamically sum the Value column when the CID and FID are the same and calculate value/total value. Total Value = -3,000,000 Data Set CID FID Type Value 130358708 198733143 L -283296.27 123218808 700636266 L -11094494.2 001973308 500381594 L -102677357