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. #6
    Registered User
    Join Date
    04-20-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Comparing data in multiple rows

    Hi,
    Thank you for the response and your suggestion. Your assumption related to the feedback always happening after the donation is correct.

    However, this doesnt work as expected when the donation date is within 10 days of NOT the immediate previous row, but one before that.

    As an example, consider rows 11 and 13 on the spreadsheet I've attached. The feedback for the donation in row #11 was sent on 2/1/2009. The donation date on row #13 is 2/2/2009. However, the indicator now shows No, since there is an intermediate entry on row #12, which does not meet this validation criteria.

    This is not an unlikely scenario, and tends to happen quite often where the feedback for an earlier donation is sent after the feedback for a more recent donation (this depends on a number of factors such as which non-profit organization the donation was made to, how soon they utilize the funds and send feedback etc.).

    Any suggestions?
    Attached Files Attached Files
    Last edited by bimalaar; 04-22-2009 at 03:42 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