rerturn latest date
If your first name is in A1 of sheet1, put this array* formula in B1:
=MAX(IF(Sheet2!A$1:A$1000=A1,Sheet2!B$1:B$1000)) adjust the ranges to suit your data, and format the cell as a date. Then copy down as far as needed. * An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) rather than the usual <enter. If you do this correctly then Excel will wrap curly braces { } around the formula when viewed in the formula bar - do not type these yourself. If you need to amend the formula you will have to use CSE again. Hope this helps. Pete On Feb 17, 7:46*pm, confused!! wrote: I have a history of password change dates each user on the system An example of how my records look: MOTON * 7/01/09 MOTON * 10/14/09 MOTON * 12/28/09 MOTON * 1/15/10 Objective is to return only the most recent or latest date change in that list of dates. *The name is already in a complete list of users so I would like to search from worksheet 1 column A list of names in worksheet 2 column B returning only the most recent or latest date change. |
All times are GMT +1. The time now is 06:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com