View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Norm Norm is offline
external usenet poster
 
Posts: 71
Default Comparing data in two columns

Column G contains new model #s, with a count of models in column F. Column E
contains existing model #s, with a count of models in column D.

In many cases, the new and existing model #s are the same. I want to
compare new models numbers to existing model numbers, and only count the
number when the two don't match. The sheet has over 500 rows of data.

Any suggestions.

--
Norm