View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ace21 ace21 is offline
external usenet poster
 
Posts: 2
Default Cell Column Comparison

I have six columns of part numbers (A-F) that I want to compare to each
other. The part numbers that are an exact match I want displayed in column G
and the number that do not match I want displayed in column H. What is the
best way to accomplish this with an Excel fomular?