Tuesday, December 9, 2014

Finding overlap between two lists in Excel

Function

=COUNTIF(C:C,K4)

Where C:C contains one list and K4 is the value. Simply drag and drop this formula for all other values in the "K" column!

No comments: