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
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...