Results 1 to 2 of 2

Thread: Find next transaction date for same customer

  1. #1
    Seeker generalledger's Avatar
    Join Date
    Oct 2016
    Location
    New Jersey, USA
    Posts
    10
    Articles
    0
    Excel Version
    2016

    Find next transaction date for same customer



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a table of transactions that include Date and Customer ID. How can I find for a transaction, the next transaction for the same customer?

    For example, a customer might have several transactions over several dates. If I look at any one of those transactions, I need to find the very next dated transaction.

    Date-----Next Date
    1/1/19--1/15/19
    1/15/19-2/2/19
    2/2/19--2/3/19
    2/3/19--(blank)

    Thank you.

  2. #2
    Seeker pinarello's Avatar
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    12
    Articles
    0
    Excel Version
    Office 365
    Instead of "date" and "customer number", your example shows "date" and "next date". This is not really helpful

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •