Comments associated to records
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
|