View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HARSHAWARDHAN. S .SHASTRI[_2_] HARSHAWARDHAN. S .SHASTRI[_2_] is offline
external usenet poster
 
Posts: 69
Default COUNT COMMON DATA


A column is having some data and i want to check how many data is repeated
in column B .
I will briefly try to explain it as follows.

A B
a a
b c
c e
d h
e i
f o
g b
h x

Here i am expecting answer as 5 as a,b,c,e and h are common in both columns.

H S Shastri