Gathering information by the most recent dates

I have an employee summary sheet, and another sheet where data will be entered by date.

On the summary sheet I want to gather only the last 3 dates that were entered.

Attached is an example.

thanks for any help.
Nick

Hi,

Just use

Please Login or Register  to view this content.

and change the last '1' to 2 & 3 for the 2nd and 3rd largest

HTH

If the dates in Col A on Aces sheet are unique why not simply use VLOOKUP ?

Nick, check out XL Help files... post back if you run into difficulties.

What is LARGE meant to represent ?

Previously you were looking to retrieve data based on a Date value...

I'm not sure you've followed the help files correctly regards VLOOKUP.

First off as I see it you have your top 3 date issue resolved c/o Richard's formula.

You need to now populate columns F, O & R based on the date value in B

To do that - you can use VLOOKUP which, per the Help files and plethora of online examples, works along the lines of:

=VLOOKUP(criteria,table_array,col_index_num[,range_lookup])

where:

The criteria is your date value in Column B

The table_array is your ACES table - ie ACES!A5:D37 ...
NOTE: the left most column of your range must contain the column in which the criteria will be resident.

Your col_index_num will vary - this determines from which column in the table_array you wish to retrieve results ...
for "Observed by" this will be 2 given this is the 2nd column in your table_array.

The last parameter being optional... in your case given the table_array is unsorted you MUST use specify this final parameter as either 0 or FALSE - this is such than an exact match is conducted
(the binary algorithm, utilise if this parameter is either omitted / 1 / TRUE can not be employed as it will return misleading results).


So as a pointer your first formula... column F

Please Login or Register  to view this content.

For the other columns you need only modify the col_index_num - all other parameters are constant.

You can if you wish look to utilise a MATCH function to create the col_index_num for you such that you do not have to modify it per column of calculations - I will leave this for you to investigate.

All of this of course is assuming the dates in Column A on Aces sheet are unique... if not the above won't work should a top 3 date be duplicated...