conting numbers of occurance ignoring double postings

A

Abdul

I have two columns

Ep#
26
26
26
26
27
27
28
28
28
28

Name
ABC
ABC
DEF
DEF
DEF
DEF
DEF
DEF

how can i count the number of occurance in Ep# column if i filter Nam
column to ABC

like if 26 is 2 times than count should give one number 27 three time
it give one number means total 2 conts

i dont know have i explained it or not?

Can any one help me?

Jabee
 
P

Peter Atherton

-----Original Message-----
I have two columns
Click to expand...
how can i count the number of occurance in Ep# column if i filter Name
column to ABC

like if 26 is 2 times than count should give one number 27 three times
it give one number means total 2 conts

i dont know have i explained it or not?

Can any one help me?
Click to expand...
Jabeer

Enter this formula asan Array (Ctrl + Shift + Enter) and
copy it down

=COUNT(IF($B$2:B4=B4,$A$2:A4))

Regards
Peter
 
A

Abdul

Peter

I am not getting the formula. Can you please explain it.

Secondly it is not working. how can i count Ep# without countin
double?

like if 26 is written twice it should be counted only once
 
Top