Here's one way, implemented into your sample at:
http://cjoint.com/?bzhGsbFjGk
fdab66_data_and_summary_1.xls
In sheet: Summary,
Array-enter (press CTRL+SHIFT+ENTER) in B4,
then copy B4 down to B7:
=INDEX(OFFSET(INDIRECT("Data!P"&MATCH(A4,Data!A:A, 0)+1),,,5),MATCH(TRUE,OFFS
ET(INDIRECT("Data!P"&MATCH(A4,Data!A:A,0)+1),,,5)< "",0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fdabb" wrote in message
...
Hi Max,
Thanks for getting back to me - I made an abridged version of the
spreadsheet which you can find he http://cjoint.com/?bzgSct1jcq
Basically I want to insert the result from the data page to the
appropriate
place on the summary page.
Thank you so much - I'd given up all hope
Cheers, Fiona.