Sort row data by date and extract to another sheet?

[D_N_L]

Hello,

I have attached an example Excel 2003 workbook. My data is on Sheet 1. What I am trying to do is to extract all the scores for 'Client 8' so it looks like what's on Sheet 2. Ideally I would like the latest scores at the top and the earliest ones at the bottom.

I can't use VBA on this project.

Can any one help?

Sorry - probably not the greatest title ever written.

[Pcguy1]

Example-1.xls

Check whether this helps or not.

[D_N_L]

Hi,

Thanks - I really need it to be formula based though. The following works but I can't figure out where to put the ISERROR function to stop it showing #N/A!

=INDEX(DB!$A$2:$L$2000,SMALL(IF(DB!$A$2:$A$2000=DB!$A$1,ROW(DB!$A$2:$A$2000)-1,""),ROW(DB!$A2)),COLUMN(DB!A$1))