Results 1 to 3 of 3

Need to match and sort data in 6 columns

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2014
    Location
    Evansville, IN
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need to match and sort data in 6 columns

    PLEASE HELP! I'm trying to put together a fairly important financial report, and I'm pretty ignorant when it comes to doing more than the most basic functions with Excel.

    Here's what I'm working on:

    Column A has donor name, column B has corresponding donation data for 2011. Column C has donor name, and column D has donation data for 2012. Column E has donor name, and column F has corresponding donation data for 2013.

    Although Columns A and C and E all have donor names, there are many changes
    from year to year with the addition and deletion of certain donors so the
    rows do not match up exactly. Is there a quick way to have the rows match up
    according to donor names in column each of the three columns? Secondarily, I need to sort by donation amount from highest to lowest (it can either be the total over the three years or based on any single year.

    Currently my list looks like this:
    2011 2012 2013
    A A A
    B C B
    D D C
    F E D
    H F I
    L G K
    M H M

    I would like it to look like this:
    2011 2012 2013
    A A A
    B - B
    C C -
    - D-
    - E-
    F F F
    G G G
    H - -
    L - L
    - - M


    Basically, I want to see the year over year giving for each donor. I've attached a sample for refrence. (I can't post the original due to confidentiality requirements.)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort and Match Uneven Columns of data
    By MustardMan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2012, 01:43 PM
  2. How to match up and sort columns with same data?
    By skizoid7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2010, 01:27 PM
  3. Sort and match whole columns' data?
    By coolieku in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2009, 12:52 AM
  4. Replies: 3
    Last Post: 02-27-2009, 10:56 AM
  5. Replies: 9
    Last Post: 07-02-2008, 06:16 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1