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. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Comparing data in multiple rows

    bimalaar, I might be missing something but presumably you can make the assumption that Feedback is always sent post Donation ?

    If so see the attached, sheet DOTE ...

    In short I sorted the data by Donor and Feedback date .. this makes the analysis much much simpler based on the above logic re: feedback/donation dates.

    Given the volume of data in play I feel this method will be far more efficient than leaving the data in it's present order and calculating using a complex LOOKUP approach...
    As it is a one-off exercise post-completion you should copy and paste the results column as values over the formulae and then resort as desired (the final column is in place to facilitate this process... or dispensing with this column just sort again by Donor/Donation Date)
    Attached Files Attached Files

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