Results 1 to 13 of 13

Comparing data in multiple rows

Threaded View

bimalaar Comparing data in multiple... 04-20-2009, 08:36 PM
bimalaar Re: Comparing data in... 04-20-2009, 09:11 PM
DonkeyOte Re: Comparing data in... 04-21-2009, 03:22 AM
bimalaar Re: Comparing data in... 04-21-2009, 06:20 PM
DonkeyOte Re: Comparing data in... 04-22-2009, 05:28 AM
bimalaar Re: Comparing data in... 04-22-2009, 03:39 PM
DonkeyOte Re: Comparing data in... 04-22-2009, 03:48 PM
JBeaucaire Re: Comparing data in... 04-22-2009, 05:01 PM
DonkeyOte Re: Comparing data in... 04-22-2009, 05:06 PM
JBeaucaire Re: Comparing data in... 04-22-2009, 07:04 PM
bimalaar Re: Comparing data in... 04-23-2009, 12:05 AM
JBeaucaire Re: Comparing data in... 04-23-2009, 12:34 AM
bimalaar Re: Comparing data in... 04-24-2009, 07:47 PM
  1. #1
    Registered User
    Join Date
    04-20-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    6

    Comparing data in multiple rows

    Hi,
    I have a spreadsheet containing donation data for a non-profit organization with over 25,000 rows. The spreadsheet contains a lot of data, and is sorted by donor name, donation date (when the donation was made) and the feedback date (feedback on how the donation was used).

    I'm looking to analyze how many transactions were made by a donor within 10 days of receiving feedback for a previous donation. The condition to check for is
    (donor name is the same) AND (donation date >= feedback data for a previous donation) AND (donation date <= feedback data for a previous donation + 10 days).

    How do I best perform this comparison? For instance, a donor may have made 20 donations, so I need to compare these donations amongst themselves and flag the ones where the donation date within 10 days of the feedback date for any other donation. I need to perform this exercise for each individual donor.

    The purpose is to assess how effective the feedbacks are, and if they're resulting in repeat donations.

    Any help will be greatly appreciated. Thanks in advance.
    Last edited by bimalaar; 04-24-2009 at 07:47 PM.

Thread Information

Users Browsing this Thread

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

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