1 2 Previous Next 21 Replies Latest reply on Oct 16, 2013 12:13 PM by Ryan Johnson

    Replacing a value based off Date

    Ryan Johnson

      In the attached sample workbook, two salespeople are associated with Acme.  The Acme account was assigned to John Anderson previously, but is now assigned to David Jones.  Since David Jones was the last person to sell to Acme, all previous activity should be listed under him now.  My question is, how do I get David Jones to show up as the salesperson for ALL Acme sales now?  I got as far as creating a MAX([Sale Date]) to get the last salesperson, but then couldn't figure out where to take it from there.  I thought about REPLACE, but that didn't look applicable.  Any ideas?

       

      Thanks,

      Ryan

        1 2 Previous Next