I ended up just sorting the rows by the comment column, then I copied the
rows I needed and re-sorted the data. I thank you for your suggestions!
--
Scott Miller
University of Washington
Chemistry


"Ron Coderre" wrote:

Try this:

Assuming your data is in columns A,B,C
A1: Data_A
A2:A100 data items

B1: Data_B
B2:B100 data items

C1: Comments
C2:C100 (Sporadic comments)

E1: Comments
F1: Data_A
G1: Data_B

I1: Comments
I2: *

Next,
DataFilterAdvanced Filter
Select: Copy to another location
List Range: A1:C100
Criteria range: I1:I2
Copy to: E1:G1
Click OK

That should list only items with comments under cells E1:G1

Does that help?

***********
Regards,
Ron


"Scott" wrote:

I need a function that will list comments associated with records if they
exist!


Records:
DataA(1-n)
DataB(1-n)
DataC(1-n)
Comment (some of 1-n)

I want to list the comments that exist like so.

Comment(n) DataA(n) DataB(n)

Kind of a stumper for me.
--
Scott Miller
University of Washington
Chemistry