Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter latest date from multiple date entries | Excel Worksheet Functions | |||
latest date | New Users to Excel | |||
X axis date - display beyond latest date. | Charts and Charting in Excel | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions |