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, Septemb
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 wrote:
> Hi Experts,
>
> I am facing some problem with th
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 wrote:
>
>
> Hi all
>
> I am new to this group so I hope someone can kindly assist..
>
> To s
Dear All,
As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro
enabled file extension then in those files macros does not work or visible.
So i want to make a restriction in macro enabled files .xlsm or .xlsb that
they cannot be saved under non-macro enabled file extension.
I hope the below one works good to you... pls check
SELECT TOP 1 * FROM MIDASQ12013
WHERE MIDASQ12013.COUNTRY IN (SELECT TOP 20 MIDASQ12013.COUNTRY,
MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08,
Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10,
Sum(MIDASQ12013.
Hello Enrique Martin,
I have been attempted this query:
SELECT MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008)
AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010)
AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012)
AS KEUR12, S
Hello,
I've got a shared workbook which is used by a number of people in my
office. It's got quite a lot of macros in it, but before I put it on the
network as a shared workbook it worked fine - it was quick to respond. Now
that I've made it a shared workbook it is horribly slow, both on openi
http://erlandsendata.no/?p=3653
On Wed, Sep 18, 2013 at 10:21 AM, Satheeshkumar Yadav <
satheesh.arumu...@gmail.com> wrote:
> Hi Expert,
>
> Any idea how to break the links in chart object in powerpoint through VBA
> code.
>
>
> --
> Thanks & regards
> Satheeshkumar
>
> --
> Are you =EXP(E:RT) o
Hello,
Thanks for your replies. Formulas are working for one set of data but its
not working for other criterias I have attached new excel could you please
check it.
*Ashish - *I am trying to get count of unique records based on multi
conditions where I know what is Condition1 but I will be not k
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rejeeb Abdulrahiman
Sent: Tuesday, September 17, 2013 10:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Check Box In Excel
Hi Friends,
In Excel 2010, I would like to create a l
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,""),""
),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,""),"")),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, September 17, 2013 6:00 PM
To: ex
11 matches
Mail list logo
