Forum Discussion
nmlynch
Jan 24, 2024Brass Contributor
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...
Harun24HR
Jan 24, 2024Bronze Contributor
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)
- djclementsJan 24, 2024Silver Contributor
Harun24HR Nice use of the reference operator (@) to return the first result of the array, rather than TAKE(array, 1, 1). I like it! 🙂