+ Reply to Thread
Results 1 to 4 of 4

Compare values in two dissimilar tables

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    USofA
    MS-Off Ver
    Excel 2010, Excel 2008 for Mac
    Posts
    6

    Compare values in two dissimilar tables

    I am putting together a departmental sales report in Excel. There will be 3 worksheets... one for raw daily sales data, one for a list of all current employees in the department, and one will will have the actual report. I cannot use VBA or macros since the bossman will be using Excel 2008 for Mac (unfortunately).

    I actually had this finished using index/match etc etc, until the bossman informed me that the raw data included employees from other departments, whereas the sales report must only contain data for employees from my department.

    Hence, I need a formula that will look at the employee code (employee initials) in the raw data, verify that it is a match of an employee in my department (same employee code), and then copy that employee code to a spot in the sales report. I want it to ignore any sales information from the raw data for an employee that is not in my department. From there, my index/match functions in the sales report can take over.

    I should add that it would be nice if the sales report were able to dynamically adjust the line in which the column totals appear so that the totals appear on the first line below the last line of the table. The number of lines in the sales report could change from day to day.

    I hope my explanation is clear. Any help would be greatly appreciated.
    Last edited by jrothstein; 07-05-2012 at 12:38 AM.

  2. #2
    Registered User
    Join Date
    06-20-2012
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Compare values in two dissimilar tables

    Hello,

    Do you have an example workbook to attach without confidential information?

    Cheers,
    Diana

  3. #3
    Registered User
    Join Date
    07-04-2012
    Location
    USofA
    MS-Off Ver
    Excel 2010, Excel 2008 for Mac
    Posts
    6

    Re: Compare values in two dissimilar tables

    Sure... here you go.

    You can see that the "Raw Data" worksheet includes employees that are not on the "Dept. Employees" worksheet. What I need this to do is populate the "Sales Report" worksheet with employee codes from the "Raw Data" worksheet that are also on the "Dept. Employees" worksheet, and ignore all other employee codes on the "Raw Data" worksheet.

    Keep in mind that I cannot use VBA or macros since the user will be using Excel 2008 for Mac.

    I know it is fairly simple, I just cant figure it out.

    Thank you.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-20-2012
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Compare values in two dissimilar tables

    Hello,

    Please find the example workbook attached.

    I hope this is what you are looking for.

    Cheers,
    Diana
    Attached Files Attached Files

+ 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