One way ...
If the 194 cells are in ColA and the 150 cells are in ColB, then at
C1 put the formula
=MATCH(A1,$B$1:$B$150,0)
and copy down to C194.
The cells in ColC that return #NA indicate the missing entries from
ColB.
Rgds,
ScottO


"Denny" wrote in message
...
| I have two different columns which should contain the same contents
but there
| are diffences. Each column should have 194 entries (cells) but one
has only
| 150. Is there a function in excel which would allow me to compare
the
| contents in each and highlight the 44 discrepancies?