$$ How to count the items except repetition
Dear Friends,
Greetings !
Request for your help on the subject matter.
I have attached the file for your reference, in which there are two
different rows which are having repetition entries and I need to count them
without deleting the
Hi Pravin,
It will also help you.
=SUMPRODUCT((C3:C39<>"")/COUNTIF(C3:C39,C3:C39&""))
Regards
On Wed, Sep 5, 2012 at 11:10 AM, Amresh Maurya wrote:
> for unique agency and unique city
>
> use this formula.
> =SUM(IF(FREQUENCY(MATCH(C3:C39,C3:C39,0),MATCH(C3:C39,C3:C39,0))>0,1))
>
> Regards
for unique agency and unique city
use this formula.
=SUM(IF(FREQUENCY(MATCH(C3:C39,C3:C39,0),MATCH(C3:C39,C3:C39,0))>0,1))
Regards
Amresh
On Wed, Sep 5, 2012 at 11:06 AM, Manoj Kumar wrote:
> Dear Amresh,
>
> if we need unique agency and unique city how can we find...
>
>
> Regard
> Manoj
>
>
Hi
You Can Also Use
*Amresh Maurya Technic *
*or pivot table for counting *
*spratley*
---
Regard
ਦੀਪਕ ਗਿਰੋਤ੍ਰਾ
+91-9911568956
੧ਓ ਸਤਨਾਮ ਸ਼੍ਰੀ ਵਾਹੇਗੁਰੁ ੧ਓ
On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal wrote:
> Dear Friends,
>
> Greetings !
>
> Request for your he
Dear Amresh,
if we need unique agency and unique city how can we find...
Regard
Manoj
On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya wrote:
> Hi Pravin,
>
> find the attached solution.
>
> use this small formula.
>
> =COUNTA(C3:C39)
>
> Regards
> Amresh
>
>
> On Wed, Sep 5, 2012 at 10:50 AM, P
Hi Pravin,
find the attached solution.
use this small formula.
=COUNTA(C3:C39)
Regards
Amresh
On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal wrote:
> Dear Friends,
>
> Greetings !
>
> Request for your help on the subject matter.
>
> I have attached the file for your reference, in which there
Dear Friends,
Greetings !
Request for your help on the subject matter.
I have attached the file for your reference, in which there are two
different rows which are having repetition entries and I need to count them
without deleting the records/ any of the rows.
Thank you.
Regards,
Pravin Gunja