Hi I need som help with a compare/sorting problem. I have 2 lists with customers and sales. I want to know which customers who has increased/decreased his sale from 2006 to 2007. The problem is that there are new customers 2007 that we did not have in 2006 and some customers who have left us from 2006 and we do not have 2007. I want to compare and sort the lists as shown in the enclosed exemplefile. As I said some of the customers did not have any turnover in 2006 but in 2007 and vice versa. If we dont have any sale 2006 or 2007 I want to fill in customer number automaticlly with no (0) sale.
Is there a way to do this. Please help
Dennis
Bookmarks