+ Reply to Thread
Results 1 to 3 of 3

Compare and sort 2 lists.

  1. #1
    Registered User
    Join Date
    01-28-2006
    Posts
    2

    Compare and sort 2 lists.

    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-31-2007
    Posts
    27
    I'm not sure exactly what you're asking, but it looks like you want to compare List 1 (2006) to List 2 (2007) financials... type the following into cell E16 next to the first customer in the "sorted" list: =IF(B16=0, "N/A", IF(D16=0, "N/A", D16-B16))

    This basically says, if there's no sale in either List 1 or 2 for a customer, don't display an increase or decrease in sales. If there are sales for both years, then show me the difference.

  3. #3
    Registered User
    Join Date
    01-28-2006
    Posts
    2
    Hello
    Yes I want to compare the 2 list 2006 and 2007. The "Sorted " list is the one I would like to have when the job is done. So I only have the "Unsorted" list right now. I want an formula to put in the red figures. If I dont have any sale in 2006 but in 2007 I want an formula to put in customer and sale for 2006.
    Customer number 10002 and 0 sale, marked with red A17 and B17.If I have sale in 2006 but not in 2007 I want a formula to put in customer number and sale for 2007, marked with red C19 and D19. I hope you understand what I mean.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1