1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

First() and Last() functions?

Does Excel have a function that is equivalent to the First() and Last () function in Access to select the first or last record in a group? I’ve been looking at GroupBy and Large functions in Excel. I came up with a workaround, but I’d prefer to use a legitimate Excel function.

submitted by /u/rlewis904
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#large dataset processing
#financial modeling with spreadsheets
#Excel
#functions
#First()
#Last()
#Access
#GroupBy
#Large
#workaround
#legitimate
#function equivalent
#select
#record
#group
#posted
#user