Saturday 23 March 2013

Excel column matching

If there are 200 cells are in ColA and 150 cells are in ColB, then at
C1 put the formula
=MATCH(A1,$B$1:$B$150,0)
and copy down to C200.

The cells in ColC that return #NA indicate the missing entries 

No comments:

Post a Comment

SharePoint Information Architecture Diagram

Here is the template I use for Information Architecture designs. It's built using Mindjet and I flesh the nodes out with the low level d...