Results 1 to 2 of 2

Excel 2007 : compare two spreadsheets in

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2009
    Location
    Paris France
    MS-Off Ver
    Excel 2007
    Posts
    6

    compare two spreadsheets in

    bonjour les amis,

    I've got two spreadsheets that i want to compare the data. The first sheet is our yearly inventory and the second sheet is our official inventory. I would like to prepare a forumula ( match or vlookup?) that compares the 2010 inventory to our official inventory and returns a list of the decrepencies (IE highlight the bikes on the global inventory that are not on the 2010 inventory)

    thanks brainiacs!
    Attached Files Attached Files
    Last edited by ekoot; 02-08-2010 at 07:57 AM. Reason: wrong worksheet attached.. duh

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