think it can be achieved with 1 basic DGET formula.
Note: ( for this example I'm assumming your data is in sheet1 have the following headings : Name,Comment1,Comment2 )
1- Create a Viewing Sheet to view summary data. In this example will we consider Sheet6 as the viewing sheet.
2- in Sheet6!A1 place subject heading like "Name", sheet6!B1 = Comment1, sheet6!C1=Comment2
3 - In Sheet6!B2 place formula =DGET(Sheet1!A:C,"Comment1",$A$1:$A$2)
4 - in Sheet6!C2 place formula =DGET(Sheet1!A:C,"Comment2",$A$1:$A$2)
Note: The A:C value in step 3 and 4 will need to be modified if you have more columns of source data ie. if you data is in rows A to D the change A:C acordingly.
This message was edited by Nimrod on 2002-05-08 10:18