Thread: From 2 rows or column how to find common numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A S Matharu A S Matharu is offline
external usenet poster
  
Posts: 1
Default From 2 rows or column how to find common numbers
I have one row with 6 columns and having different numbers say from A1 to F1
Then i have one column with 20 different numbers say from H1 to H20. But
there are common numbers between this row and the column. I want to find the
common or repetitive numbers by comparing row with the column. And also tolal
common numbers between this row and column.
Reply With QuoteReply With Quote