Forum Discussion

Brass Contributor

Jan 24, 2024

Combining VLookup, max and other formulas to find customer's most recent visit - guidance?

Hello! Looking for some help with a formula - attaching an example spreadsheet with some simple data. My data are in two tabs - it needs to stay that way. On the second tab, I would like a formula th...

Need help on an Excel formula.xlsx10 KB

excel

Excel on Mac

Formulas and Functions

Harun24HR

Bronze Contributor

Jan 24, 2024

nmlynch Use FILTER() function with SORT().

=@SORT(FILTER('Raw Visit Data'!$C$3:$D$17,'Raw Visit Data'!$B$3:$B$17=B3),2,-1)

Need help on an Excel formula.xlsx12 KB

nmlynch
Brass Contributor
Jan 24, 2024
Harun24HR - Fantastic! Thank you - it works beautifully. Clearly way more complicated than I'd envisioned. I'm very grateful for your help.
djclements
Silver Contributor
Jan 24, 2024
Harun24HR Nice use of the reference operator (@) to return the first result of the array, rather than TAKE(array, 1, 1). I like it! 🙂