+ Reply to Thread
Results 1 to 2 of 2

Matching new data with existing database

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    Brazil
    MS-Off Ver
    Excel 2016
    Posts
    46

    Question Matching new data with existing database

    Hello.

    I got a database with the evolution of my sales across time. Each row represents a product and the columns represents equal gaps of time. The value of each cell is the amount sold. From that you can draw curves for each product.

    Now I have a new product, or a new curve, and I want to know which of the existing curves matches the best with the new one.

    Which is the best way to do that?

    Thanks for the attention.

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    813

    Re: Matching new data with existing database

    You could create a helper column to compare lets say 2 columns of your choice. Col B results divided by Col C results. (This would include your new product and curve)
    Highlight all your new helper column results.. Right click and choose Quick Analysis; select color scale. The resulting color closest to your new product and it's curve is the closest match.
    HTH.

    Pete

+ 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. Replies: 3
    Last Post: 01-19-2014, 12:27 PM
  2. Macro for inserting row and adding data to an existing database
    By navwelch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2013, 03:46 AM
  3. Macro to copy and paste data into database
    By kayoke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 05:00 AM
  4. Replies: 2
    Last Post: 06-11-2012, 05:36 AM
  5. Macro to update database without replacing existing data
    By kayoke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2012, 04:33 AM
  6. Merging data from database with existing list
    By pdewachter74 in forum Excel General
    Replies: 0
    Last Post: 04-29-2009, 07:48 AM
  7. Replies: 3
    Last Post: 01-05-2006, 12:59 PM

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