Excel formula problem

[mcbtiger]

yare mare excel may masla hai kya manay duplicate count karna lakin three colume ko match kar na hai example
=IF(COUNTIF(C2:C4,C2),COUNTIF(B2:B4,B2),COUNTIF(A2 :A4,A2)) yare ya sirf two colume per kam kar raha hai lakin third colume per kam nahi kar rah hai
colume A Colume B colume C
DepositeSlip ClientName PhoneNo Count
1234506 Aleem 0211234506 2
1234506 Aleem 0211234506
1234507 Saleem 0211234507 1




[

[imranjhang]

sir please question zara detail main bata dain....... abhi question clear nahi huwa

[aliraza3992003]

DepositeSlip ClientName PhoneNo Count
1234505 a 52352345 1
1234506 b 3425254 1
1234507 c 4532423 1

kia aap kee requirement yee hay

[syar]

Aap k problem k leye waise tu bohat se method hain. Leekan 3 easy ways.

1. As per your sample data agar duplicate aik dosra k neeche hain tu try this

=IF(A2=A1,"",SUMPRODUCT(--($A$2:$A$4=A2),--($B$2:$B$4=B2),--($C$2:$C$4=C2)))

2. Agar duplicate aik dosre k neeche nahee hain tu try this traditional function

=SUMPRODUCT(--($A$2:$A$4=A2),--($B$2:$B$4=B2),--($C$2:$C$4=C2))

3. Ye tradional sumproduct se bohat zayada fast formula ha. Is ko enter karne k leye aap forumla copy karain/ya lekhain tu phir "Contorl+shift+Enter" Aik saath press karain aur formula ko neeche jahan tak require he copy kar dain

=SUM(($A$2:$A$4=A2)*($B$2:$B$4=B2)*($C$2:$C$4=C2))

Note: Ranges/refrences ko zarrorat k mutabiq change kar lain. Dosra Apni ranges ko absolute karain warna aap ka post NO.1 k formula k tarah wrong answer mele ga.
Behtar ho ga k aap screen shot dain ya apni file attached karain.

regards