I posted a reply that I do not read ...
I had a formula in Italian and translated into English forgetting to
change the separator to rewrite the arguments correctly ...
then ... try:
=SUM(N(FREQUENCY(IF(B1:B10>0,MATCH(A1:A10,A1:A10,0)),MATCH(A1:A10,A1:A10,0))>0))
regards
r
On 14 Set, 19:25, Di
or other than the logic which you
have suggested here below.
Please note that the souce data for pivot is around 50K.
-- Forwarded message --
From: Dilip Pandey
Date: Wed, Sep 15, 2010 at 10:40 AM
Subject: $$Excel-Macros$$ Re: unique Countif
To: Manoj Kukreja ,
"excel-macr
try this function:
=SUM(N(FREQUENCY(IF(B1:B15<>0,MATCH(A1:A15;A1:A15;0)),MATCH(A1:A15;A1:A15;0))>0))
CTRL+SHIFT+ENTER:
regards
r
On 14 Set, 19:25, Dilip Pandey wrote:
> Hi Manoj,
>
> Please find the solution attached with this email.
>
> Note:- Going forward please mark Group as well so tha
You are welcome Manoj...!! :)
Best Regards,
DILIPandey
On 9/15/10, Manoj Kukreja wrote:
> Thanks Dilip.
>
> -Original Message-
> From: Dilip Pandey [mailto:dilipan...@gmail.com]
> Sent: Tuesday, September 14, 2010 10:56 PM
> To: excel-macros@googlegroups.com
> Cc: Manoj Kukreja
> Subject
Hi Manoj,
Please find the solution attached with this email.
Note:- Going forward please mark Group as well so that every one gets
equal chances of learn and to help others :)
@ Group:- I have also attached the original query (image003.png) in
this email so that all can understand the query.
G
