Forum Discussion

JPAlves89's avatar
JPAlves89
Copper Contributor
May 26, 2023
Solved

How to find the latest update on a list of accounts

Hello everyone! I'm looking for some help on a set of data where I have account numbers with update dates and times. Each time there's an update on one of these accounts, there is another entry on ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 26, 2023

    JPAlves89 

    You can use a formula of the form

     

    =MAXIFS(date_range, account_range, specific_account)

HansVogelaar's avatar
HansVogelaar
MVP
May 26, 2023

JPAlves89 

You can use a formula of the form

 

=MAXIFS(date_range, account_range, specific_account)

  • JPAlves89's avatar
    JPAlves89
    Copper Contributor
    May 26, 2023
    Thank you very much.
    That definitely did the trick!

Resources