+ Reply to Thread
Results 1 to 2 of 2

Checking data in different formats

  1. #1
    Registered User
    Join Date
    06-20-2019
    Location
    Atlanta, GA
    MS-Off Ver
    16
    Posts
    1

    Checking data in different formats

    I have two sheets I want to compare to see if all the data in one is in the other. However they are set up different. They are accounts of wholesale ice cream sales, and there are 6 total products: 3 flavors (choc., van., straw.) and 2 sizes (qt., pt.). Each customer buys some combination of the 6 products (most buy at least 1 of each but that's not guaranteed)

    The first sheet has the following columns:
    Customer Name
    Choc. pt.
    Van. pt.
    Straw. pt.
    Choc. qt.
    Van. qt.
    Straw. qt

    Each row contains a new unique customer and the quantity of each ice cream tub that they buy.


    The second sheet has the following columns:
    Customer Name
    Flavor
    qt.
    pt.

    Each row in this sheet has a customer name with a flavor (either Choc., Van., or Straw.) and then the quantity of each tub size that they buy. In this case, a customer name can be repeated up to three times if they buy some of all three flavors.


    How can I manipulate this data so that I can make sure these two sheets are recording the same information. There are lots of instances, so a macro or a function would be ideal. How can I do this? Any insight is very appreciated!

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,622

    Re: Checking data in different formats

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Checking Range, altering out of bounds, checking result against table
    By Sillystring in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-11-2016, 06:47 AM
  2. Replies: 4
    Last Post: 10-01-2014, 03:18 PM
  3. [SOLVED] PasteSpecial with number formats but without conditional formats or borders
    By bodhi808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 09:58 AM
  4. Problem copying Page formats and print formats to another workbook
    By Chrisgeni in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2013, 08:05 AM
  5. Checking two data sets that are in completly different formats??
    By bopsgtir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2012, 03:34 PM
  6. Checking and Changing Date Formats
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2012, 03:34 AM
  7. Copying formats - column widths, formats, outlining to worksheets
    By DavidBr318 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2005, 09:05 AM

Tags for this Thread

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