-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 =COUNTIF(A2:A595
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 kumar.ashish...@gmail.comwrote:
Dear Seniors,
I want total
Dear Seniors,
I want total count of unique User ID's. These are 594 ID's in data. But
unique is 308. I want only unique user ID's count. and the output is 308
which i want. kindly help. and find the attachment.
Thanks,
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
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
kumar.ashish...@gmail.com wrote:
Dear Seniors,
I want total count of unique User ID's.
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
Software
Dear Ashish,
find the same with formula.
*Regards,
Prafull Jadhav
9920553518*
On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Anil,
Can you please help me to reslove this query through Excel formula.
Thanks,
Ashish
On Monday, September 23, 2013
=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
@googlegroups.com
Subject: $$Excel-Macros$$ Total Count of Unique ID's
Dear Seniors,
I want total count of unique User ID's. These are 594 ID's in data. But
unique is 308. I want only unique user ID's count. and the output is 308
which i want. kindly help. and find the attachment.
Thanks,
Ashish
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,
Use this =SUMPRODUCT(1/COUNTIF(A2