View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB
 
Posts: n/a
Default comparing column values

Check help for the match function.

"gall" wrote:

I have two columns with product numbers in them. The first column has
product numbers from the begining of the month. The second column has
product numbers from the end of the month.

I would like to compare them against eachother and find all the new product
numbers. So the new product numbers in the second column.

I was thinking there might be a function to do this but can't figure this
out.

Thanks,
Tricia Gall