Thread: Comprare two
View Single Post
 
Old 03-19-2012, 08:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi aayushagra,

Assuming your data are in columns A & B, you can use the following formula in C1 and copy down as far as needed:
=COUNTIF(A:A,B1)
This will tell you which values in column B also appear in column A, and how often.

Similarly, if you use the following formula in D1 and copy down as far as needed:
=COUNTIF(B:B,A1)
it will tell you which values in column A also appear in column B, and how often.

If you then convert the formulae to values, you can then sort the data by column C or D.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote