Hi,

I have a worksheet (Faculty Data Received) into which I call data from two other workbooks into its rows; included in the data are names of staff at Col A and Dates at Col B. I need to extract the data into a separate sheet for the ten latest (by date) entries for each member of staff - I am using this for the 'earliest' date and then have 9 other equations which capture 2nd smallest, 3rd smallest etc on rows below it (I have shown the first 2):

{=INDEX('Faculty Data Received'!$B$1:$B$1500,SMALL(IF('Faculty Data Received'!$A$1:$A$1500=A1,ROW('Faculty Data Received'!$A$1:$A$1500),""),1),1)}

{=INDEX('Faculty Data Received'!$B$1:$B$1500,SMALL(IF('Faculty Data Received'!$A$1:$A$1500=A1,ROW('Faculty Data Received'!$A$1:$A$1500),""),2),1)}

My problem is that where the dates are drawn from one of the two other workbooks it appears lower down on the Faculty data Received worksheet and the INDEX SMALL function is not picking up these entries.

I hope I have made this clear and that somebody may be able to help.

Many thanks in advance.