Results 1 to 14 of 14

Compare a column with different columns and find the most similar column to it

Threaded View

  1. 01-16-2020, 03:05 PM #1
    Sarangsood
    Sarangsood is offline
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Compare a column with different columns and find the most similar column to it

    I have a data of 12 years from 2008-19. I want to compare 2019 with all the years and find which is the most 'similar' year to it statistically.
    Attached Files Attached Files
    Last edited by Sarangsood; 01-17-2020 at 01:12 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare multiple columns (column A,column B,Column C) and return value (Column D)
    By john008 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2015, 08:24 AM
  2. Compare columns A & B, list unique rows of column B in column C
    By Jim in PGH in forum Excel General
    Replies: 6
    Last Post: 05-07-2014, 12:13 AM
  3. Compare two columns - If the text of one column is present in the other column
    By paulocintra in forum Excel General
    Replies: 5
    Last Post: 08-16-2013, 02:46 AM
  4. VBA code for Compare two column and find the unmatch item in another column
    By SAI2050 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 03:11 AM
  5. [SOLVED] Compare 4 column values then insert a 5th columns value to a blank column/cell value
    By JasonKMcCoy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2012, 06:01 PM
  6. compare 2 columns and create new column with missing values in second column
    By Jroelan2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 12:33 AM
  7. Find similar words in column A, report quantity in column B
    By ADSK in forum Excel General
    Replies: 3
    Last Post: 06-06-2009, 12:18 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1