Sort by name, date descending. First cell for a name will be the latest info.
Use a pivot table to display 1 entry per DSN. http://chandoo.org/wp/2010/09/27/remove-duplicates-using-pivot-tables/ On Tue, Jan 24, 2012 at 10:49 AM, Binyamin Dissen <[email protected]> wrote: > I have a spreadsheet with > > Date Name Otherstuff > > columns. > > The spreadsheet is in DATEorder (if that is relevant). > > There are multiple identical NAME entries. > > What function will give me the latest/highest DATE value for a given NAME > value in a cell? > > -- > Binyamin Dissen <[email protected]> > http://www.dissensoftware.com -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
