Try the below formula:
=SUM(1/COUNTIF(A2:A595,A2:A595))
After entering this formula, you must press *Ctrl-Shift-Enter.* It will
give the desired result*.
*
Best,
Manoj Kumar*
*
On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar wrote:
>
>
> Dear Seniors,
>
>
> I want total count of unique User ID
-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Total Count of Unique ID's
Very short & Cute formula... Thanks a lot for sharing this with group.
Can you please explain how it is calculating.
I have tried to check each piece of formula but could not got a clue
only &qu
can share other uses of "SUMPRODUCT"...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Excel Beginner
Sent: 24 September 2013 00:01
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Total Count of Unique ID's
Hi Ashish,
Hi Ashish,
Use this " =SUMPRODUCT(1/COUNTIF(A2:A595,A2:A595)) "
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Kumar
Sent: Monday, September 23, 2013 11:49 AM
To: excel-macros@googlegroups.
=SUM(IF(FREQUENCY(MATCH(A2:A595,A2:A595,0),MATCH(A2:A595,A2:A595,0)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Kumar
Sent: Monday, September 23, 2013 11:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Total Count of U
Dear Ashish,
find the same with formula.
*Regards,
Prafull Jadhav
9920553518*
On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar wrote:
> Dear Anil,
>
> Can you please help me to reslove this query through Excel formula.
>
> Thanks,
> Ashish
>
>
> On Monday, September 23, 2013 12:15:31 PM UTC+5:30
Dear Anil,
Can you please help me to reslove this query through Excel formula.
Thanks,
Ashish
On Monday, September 23, 2013 12:15:31 PM UTC+5:30, अनिल नारायण गवली wrote:
>
> Dear Ashish,
>
> See d attached workbook.
>
> Wam Regards,
> Gawli Anil
> Thanks & Regards,
> Gawli Anil Narayan
> S
Dear Ashish,
See d attached workbook.
Wam Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar
wrote:
>
>
> Dear Seniors,
>
>
> I want total count of unique User ID's. These are 594 ID's in
