Dear Melimob,
Pl share a workbook with us.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 18, 2013 at 12:29 AM, Melimob melissasobrien...@gmail.com wrote:
Hi all
I am new to this group so I hope someone can
Dear Indrajit
Workbooks.Open fil,,false
Try using above code .
Pl reply
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.com wrote:
Hi Experts,
I am facing
PFA OR USE
=SUM((C2=IF(FREQUENCY(MATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0),M
ATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0))0,$A$2:$A$15))*1) WITH
CSE
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Wednesday, September
Hi Experts
Hope you all doing good...
i need help on summing the data for the grouped range boundaries file
attached for the easy reference...
thanking you...
murali..
--
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
Both of you are simply AWESOME!!!
Just need a small change, I actually want consolidate a particular range
from the salve files, like from A3:L3, not the whole file, actually it's
consolidating the whole file!
Guys can you do some changes on it, and revert me the same.
Thanks in advance.
Respected Murali,
Just try the Indian comapnies tickers in place of foreign companies or
there may be a different URL for Indian companies in Yahoo finance.Have you
checked that aspect also?As I am a novice or rookie in VBA ,I cannot help
you in that angle.Our experts may be of your help and
Hello,
Thank a lot its working fine.
Regards,
Chandra
On Thu, Sep 19, 2013 at 12:08 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA OR USE
=SUM((C2=IF(FREQUENCY(MATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0),MATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0))0,$A$2:$A$15))*1)
WITH
Respected vijay,
Thank you very much for the support,
i have tried with indian codes only, unfortunately its not working...
On Thu, Sep 19, 2013 at 1:22 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Murali,
Just try the Indian comapnies tickers in place of foreign companies or
Thanks a lot bro. :D
It works like a charm. :D
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended recipient you are
https://www.facebook.com/photo.php?fbid=166626683530877set=a.122721837921362.1073741826.122708611256018type=1theater
--
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 @
I have created an MS Query using our SQL database. One of the fields,
which is a varchar(max) field, will not pull over.
Any suggestions would be greatly appreciated.
Thanks in Advance.
Rich
--
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)
Hi,
I have a two slice pie chart and the first slice should face to the right
centre horizontally.
Can you provide a macro for this.
Thanks for your help in advance.
Regards,
Joseph
--
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
I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke
menu to do most of the work through macros.
In 2013 the Menu appears as an Add-in with the subitems expandable
beneath it. I woud like to get back to having a bespoke menu but having
the individual macros a add-ins
Hi Sire,
Need your help, I googled a lot for this but couldn't find a solution.
Scenario is:
I have my data say in cell starting from C3, under header C2. I want to
just copy the content of cells having values not blank cells using radio
button=COPY.
Cahce is:
Range is not constant, it
Hi Chandra Sekar ,
Use the below formula.
=ROUNDUP(SUM(1/COUNTIF(B2:B15,B2:B15)*IF(A2:A15=C2,1,0)),0) with
ctrl+shift+enter.
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
Hi Enrique,
I've attempted this Query but I didn't get results. They return this
advertence, saying that I need to use the clausule EXISTS.
SELECT TOP 1 * FROM MIDASQ12013
WHERE MIDASQ12013.PAIS EXISTS (SELECT TOP 20 MIDASQ12013.PAIS,
MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08,
Thanks for the link but I do not think this will work for me, do you have
any other suggestions?
On Thursday, September 19, 2013 9:04:58 PM UTC+1, Brett Manning wrote:
Hello,
Hope everyone is well. I think I have a really simple question but I am
struggling! I am looking for a cumlative
Hi Brett,
Hope this link will solve your problem.
http://www.contextures.com/xlPivot14.html#percent
On Thursday, 19 September 2013 15:04:58 UTC-5, Brett Manning wrote:
Hello,
Hope everyone is well. I think I have a really simple question but I am
struggling! I am looking for a
Hello,
Hope everyone is well. I think I have a really simple question but I am
struggling! I am looking for a cumlative total across columns, please see
example data below:
Basically I want the first column in the Pivot table to be the Opening
value then the next column to take the opening
https://lh6.googleusercontent.com/-L9K0zTBg2rE/UjtYTXMt16I/AEI/-7Q6ckNslx8/s1600/Excel+Menu.jpg
On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote:
I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke
menu to do most of the work through
Hi Dave,
Since many of us have switched to Excel 2007 or above, it would be nice if
you can attach a picture of this bespoke menu, and then try to relate to
what you are expecting in your new version of Excel.
Regards,
Sam Mathai Chacko
On Thu, Sep 19, 2013 at 8:38 PM, Dave Tomlinson
Sorry about the multiple pastes.
In my original message I should have said In Excel 2013 I get the Dad's
Running menu on the add-ins bar. The pull down brings up the sub menu
which I have pasted to the right. This is from another of my spreadsheets
so the captions and Macro names are
Gud mornig excel expert,
Can I am join this group.
On Sep 19, 2013 11:09 PM, excel-macros@googlegroups.com wrote:
Today's Topic Summary
Group: http://groups.google.com/group/excel-macros/topics
- Pivot Table - Cumlative Totals #141387c6e1c89611_group_thread_0 [3
Updates]
- Can I
All websites will get Indian companies stock prices data from nseindia.com
and bseindia.com.
If you want to get stock quotes of indian companies based on stock code you
can get that data directly from the above websites sites, instead of
depending on third party sites.
Regards,
Kishan Reddy K
can you share your access database?
On Thu, Sep 19, 2013 at 10:40 PM, Michael Pablo skypablo...@gmail.comwrote:
Hi Enrique,
I've attempted this Query but I didn't get results. They return this
advertence, saying that I need to use the clausule EXISTS.
SELECT TOP 1 * FROM MIDASQ12013
Please do share your file.
On Fri, Sep 20, 2013 at 1:34 AM, Brett Manning brettmannin...@gmail.comwrote:
Hello,
Hope everyone is well. I think I have a really simple question but I am
struggling! I am looking for a cumlative total across columns, please see
example data below:
Basically
i am not able to do it. will you please send me file after removing
password from workbook.
On Wednesday, September 18, 2013 12:01:06 PM UTC+5:30, ravinder negi wrote:
Try this code…
Sub unprotecsheet()
Dim wb As Workbook
Dim sh As Worksheet
Set wb = ThisWorkbook
For Each
Dear Vijay,
I am not able to do it. plese send me file after releasing password.
On Wednesday, September 18, 2013 12:21:19 PM UTC+5:30, vijay wrote:
Respected Prabhakar,
Install and use the attached add-in to unprotect the workbook.
Regards,
VIJAYKUMAR
On Wed, Sep 18, 2013 at
Hi Richard,
Your query is not clear enough. Varchar is a reserved word for sql. are you
using max function for getting maximum value of a column?
If possible, please share your file..
Regards,
Anoop
Sr. Developer
On Thu, Sep 19, 2013 at 9:42 PM, Richard richard.m...@gmail.com wrote:
I have
29 matches
Mail list logo