none
Highlight rows based on difference of values between them RRS feed

  • Question

  • Hello all,

    Given the following example data, how can I highlight (or otherwise call attention to) rows for which the due dates for a given customer are less than 90 days apart?

    Customer Due Date
    Customer A 4/10/2020
    Customer B 4/24/2020
    Customer C 2/21/2020
    Customer C 4/22/2020
    Customer D 2/14/2020
    Customer D 5/15/2020
    Customer E 2/21/2020
    Customer E 5/11/2020
    Customer F 2/21/2020
    Customer F 5/22/2020

    I'd want to filter the above data in such a way as to only end up with the following, since they're the ones whose Due Dates are less than 90 days apart:

    Customer Due Date
    Customer C 2/21/2020
    Customer C 4/22/2020
    Customer E 2/21/2020
    Customer E 5/11/2020

    Thank you for any suggestions!

    Wednesday, January 29, 2020 7:38 PM

Answers

All replies