View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RobertSE6[_2_] RobertSE6[_2_] is offline
external usenet poster
 
Posts: 5
Default How can I find out if numbers in one column are also in a secondcolumn please?

Hello - I hope someone can help please - I'm a bit of a novice it has
to be said !

I have 2 columns of about 800 numbers (varying number of digits
between 6 and 8) and I need to find out how many of the numbers in
column A are also in column B. I just need a total really - don't need
to know which numbers recur

I've been looking at countif and lookup and match and getting very
confused !

It sounds like it should be easy but I'm stumped

Can anyone sort me out?

Robert