I want it to be dynamic and not require playing with the data. If a new Date/Name is added with a later Date for Name, I want the latest date field to be automatically updated.
On Tue, 24 Jan 2012 11:28:09 -0600 Mike Schwab <[email protected]> wrote: :>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 Director, Dissen Software, Bar & Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
