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.
|